Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
138
Views
Topic starter
Hi,
I thought this would be simple but I can’t get it right.
I need a formula that will meet these criteria:
If cell A is "Routine" and cell B is => 5 days this is a “pass”
If cell A is "Routine" and cell B is < 5 days this is a “fail”
If cell A is "Urgent" and cell B is => 2 days this is a “pass”
If cell A is "Urgent" and cell B is < 2 days this is a “fail”.
I was able to get this to work for "Routine" but wasn't able to add in "Urgent" to the formula.
Can anyone advise please?
Thanks,
Steve
Posted : 24/07/2019 5:02 am
Hello,
Assuming that you want this check per row, try with this.
=IF(OR(AND($A2=”Routine”,$B2>=5),AND($A2=”Urgent”,$B2>=2)),”Pass”,”Fail”)
Posted : 24/07/2019 5:28 pm
