If/Or Formula


Good morning, Community! The intent of the formula below is if the HRSA (P) is either OCS or OLCP then the Non-LIP column should by "Y" otherwise, it should be "N". With the current syntax though, I'm getting an #UNPARSEABLE error and could use an assist, please.

Best Answer

  • Kimberly Loveless
    Kimberly Loveless ✭✭✭✭✭✭
    Answer ✓

    I think it is close but should be

    =IF(OR([HRSA (P)]@row="OCS",[HRSA (P)]@row="OLCP"),"Y","N")

    all of the functions use comas not semi-colons and you would need to close the Or function before adding what the if statement should return