Nested IF Statements

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

 

[Frank Kabel]

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","")

 

[Andy B]

Carl

Try this!!

10,C3<20,B3>0.8),AND(C3>20,B3>1)),"OK","")

Andy.