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.

[TABLE="width: 250"]
[TR]
[TD]Category[/TD]
[TD]Status[/TD]
[TD]Results[/TD]
[/TR]
[TR]
[TD]High[/TD]
[TD]Regular[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD]High[/TD]
[TD]Express[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]Critical[/TD]
[TD]Express[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]Medium[/TD]
[TD]NA[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD]Critical[/TD]
[TD]Regular[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD]Not Specified[/TD]
[TD]Express[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[/TABLE]

 

[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