IF function not working

[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?

 

[Peo Sjoblom]

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

or else you wouldn't have included 10 at all


--


Regards,


Peo Sjoblom

 

[Brad]

Try this
=IF(BF26="","",IF(BF26<10,"GOOD",IF(BF26<20,"FAIR","POOR"))).

 

[pdberger]

Loren --

Try

=IF(BF26="","",IF(BF26<10,"Good",IF(BF26<20,"Fair","Poor")))


HTH

 

[Ron Rosenfeld]

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