Thread: Return with an "OK" if the value falls between -10 and 30
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
  
Posts: 3,268
Default 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


Reply With QuoteReply With Quote