How to extend the IF statement ?

  • Thread starter Thread starter ss
  • Start date Start date
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"
 
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
 
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.
 
Back
Top