Forum Discussion
AND/OR Function
I am trying to write the formula, to where one two cells must meet three different range criteria to come back "yes" or "no".
I need the cells to look something like this (I got it, its a hot mess): =IF(OR(B5>89,A5<7,B5>=80,A5>=4,B5>=70,A5>2),"Yes","No"), meaning that cell B5 must be ranged from 100-90 and A5 must be less than 7; or cell B5 must be ranged from 80-89 and A5 must be less than 4; or cell B5 must be ranged from 70-79 and A5 must be less than 2. If so, then "yes" is the repsonse, and if not, "no" is the repsonse.
I have fogotten a lot about using Excel, after not using it for the last three years.
Hi Walter,
Perhaps something like
=IF( OR( AND(B5>=90, A5<7), AND(B5<90, B5>=80, A5<4), AND(B5<80, B5>=70, A5<2) ), "yes", "no" )Sergei,
It works like a champ. You are awesome. Thank you for fixing this for me!
