Nested IF Statements

  • Thread starter Thread starter Carl
  • Start date Start date
C

Carl

I am trying to write an IF Function to do the following...

If Cell C3 is less than 2 and Cell B3 is greater than .25
return OK
If Cell C3 is between 2 and 5 and Cell B3 is greater
than .40 return OK
If Cell C3 is between 5 and 10 and Cell B3 is greater
than .50 return OK
If Cell C3 is between 10 and 20 and Cell B3 is greater
than .80 return OK
If Cell C3 greater than 20 and Cell B3 is greater than
1.00 return OK

I tried but got confused.

Thank you in advance.
 
Hi Carl
not tested but try
=IF(OR(AND(C3<2,B3>0.25),AND(C3>=2,C3<5,B3>0.4),AND(C3>=5,C3<10,B3>0.5)
,AND(C3>=10,C3<20,B3>0.8),AND(C3>=20,B3>1.0)),"OK","")
 
Back
Top