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

P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show value from one cell in another cell if today falls between a date range 5
IF AND Function Date Range Issues 6
Complex Vlookup 1
SUMIF between date range 0
SUMIF between 2 dates 1
Count if data falls within a range AND that has a certain criteria 1
Lookup value that falls between two values in a range and then som 2
Sorting and filtering text 0

Top