How to extend the IF statement ?

S

ss

This is the formula I am using...
=IF(D17<0,"Problem",)

I would like to add to the formula so that if D17 is between 1-90 it
reads "ok"
 
C

Cimjet

Hi
From what I can read, I assume the numbers can go below 0 but not higher then
90. Try this...
=IF(AND(D17>=1,D17<91),"OK","Problem")
Cimjet
 
S

ss

Hi
From what I can read, I assume the numbers can go below 0 but not
higher then 90. Try this...
=IF(AND(D17>=1,D17<91),"OK","Problem")
Cimjet
Click to expand...
Yes that was spot on.
Thanks for adjusting the formula for me.
 

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

Help with formula 1
Bugs Found in Excel 2015 0
Dragging a formula down isn't working - where am I going wrong? 1
Using IF with SEARCH 3
How to do this total? 4
Query about a formula I'm working on 1
Page numbering with Merged Document and IF statements 1
IF Statement 5

Top