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.
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 |