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,B 26<20),"FAIR","POOR")))

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


--


Regards,


Peo Sjoblom


"Loren" wrote in message
...
I am typing this function in cell BR26 -
=IF(BF26="","",IF(BF26<10,"GOOD",IF(BF2610<20,"FA IR","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?
--
Thanks, Loren