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"]

99992BY

9309 RY

[/td]0513 BYL

[/td]8018 Y

[/td]W0319 RN

[/td]0312 BN

[/td]9708 BY

[/td]0412 BY

[/td]0412 BY

[/td]

[/TABLE]

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

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

[/TABLE]