IF function not working

  • Thread starter Thread starter Loren
  • Start date Start date
L

Loren

I am typing this function in cell BR26 -
=IF(BF26="","",IF(BF26<10,"GOOD",IF(BF26>10<20,"FAIR","POOR"))). If I have
from 1 to 9 in cell BF26 it reads GOOD but anything above 10 cell BR6 reads
POOR. What is wrong with my formula?
 
Your formula does not work but the IF function certainly does, you need to
add AND

=IF(BF26="","",IF(BF26<10,"GOOD",IF(AND(BF26>=10,B26<20),"FAIR","POOR")))

also note that I put
= 10
Click to expand...
or else you wouldn't have included 10 at all


--


Regards,


Peo Sjoblom
 
BF26>10<20

Not sure how you derived this syntax.

If what you want is to test for the condition where BF26 is greater than 10 and
also less than 20, the proper syntax is:

AND(BF26>10,BF26<20)

If you want something else, you'll need to spell it out in more detail.



--ron
 
Back
Top