How to return with an "OK" if the value falls between -10 and 30
P Peo Sjoblom Aug 21, 2008 #2 =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
=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
