If/Or Formula

Chris Hallo

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.

Kimberly Loveless

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

Kimberly Loveless

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

Chris Hallo

Perfect, thank you Kimberly Loveless!