IF function not working

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

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
Click to expand...
or else you wouldn't have included 10 at all


--


Regards,


Peo Sjoblom
 
D

David Biddulph

IF(BF26>10<20,... is not valid syntax for what you presumably intend.

IF(AND(BF26>10,BF26<20),... is what you are trying to say, but of course you
have omitted the case where BF26 is *equal* to 10 (so this would give POOR,
along with the cases for BF26>=20). If this should be included in the
condition, as IF(AND(BF26>=10,BF26<20),..., then all you need to say is
IF(BF26<20,... because you've already tested for BF26<10 so you don't go on
to the later test unless BF26>=10.
 
R

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
 
Top