Return with an "OK" if the value falls between -10 and 30
 

How to return with an "OK" if the value falls between -10 and 30

Return with an "OK" if the value falls between -10 and 30
 

=IF(AND(A2=-10,A2<=30),"OK","Not OK")

replace A2 with the cell in question and change <= and = to < and
if you don't want to include -10 and 30



Regards,


Peo Sjoblom



"Jas" wrote in message
...
How to return with an "OK" if the value falls between -10 and 30