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]