# If formula with options

• I am trying to make a formula that will see if a column contains either "R", "B", or "D". If it does contain on of those then return a "Y" otherwise return a "N".

=IF((ISNUMBER(FIND({"R","B","D"},[A.B.C.D.]))),"Y","N")

This formula almost works but will only return a "Y" if the cell contains an "R" or whichever one I first.

EX.

=IF((ISNUMBER(FIND({"R","B","D"},[A.B.C.D.]))),"Y","N") ONLY RETURNS IF IT CONTAINS "R"

=IF((ISNUMBER(FIND({"D","R","B"},[A.B.C.D.]))),"Y","N") ONLY RETURNS IF IT CONTAINS "D"

=IF((ISNUMBER(FIND({"B","D","R"},[A.B.C.D.]))),"Y","N") ONLY RETURNS IF IT CONTAINS "B"

[A.B.C.D.] is the column that we are looking at and it has values that look like the following:

[TABLE="border: 0, cellpadding: 0, cellspacing: 0, width: 72"]

[tr]

[td]

99992BY

[/td]

[/tr]

[tr]

[td]

9309 RY

[/td]

[/tr]

[tr]

[td]

0513 BYL

[/td]

[/tr]

[tr]

[td]

8018 Y

[/td]

[/tr]

[tr]

[td]

W0319 RN

[/td]

[/tr]

[tr]

[td]

0312 BN

[/td]

[/tr]

[tr]

[td]

9708 BY

[/td]

[/tr]

[tr]

[td]

0412 BY

[/td]

[/tr]

[tr]

[td]

0412 BY

[/td]

[/tr]

[/TABLE]
[TABLE="border: 0, cellpadding: 0, cellspacing: 0, width: 48"]

[tr]

[TD="width: 64"] [/TD]

[/tr]

[/TABLE]

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!