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]