IF(OR/AND) Formula

[zinah]

Hi,

I was trying to use IF, AND, OR formula to build the condition below but I'm not sure why it's not working.

The condition should be: if Category is high or Critical and Status is Express then it's TRUE, otherwise False. The results column is the desired results.

Category	Status	Results
High	Regular	FALSE
High	Express	TRUE
Critical	Express	TRUE
Medium	NA	FALSE
Critical	Regular	FALSE
Not Specified	Express	FALSE

 

[Fluff]

How about
=IF(AND(OR(A2={"High","Critical"}),B2="Express"),TRUE)

 

[zinah]

Awesome! Thank you so much @Fluff

 

[Fluff]

You're welcome & thanks for the feedback