3 Different Values

[Loren]

I have a value in Cell BF32 of 13.43 and want cell BR32 to show the following:
If BF32 = 0 then leave cell BR32 blank
If BF32 is less than 10 then BR32 should = GOOD
If BF32 is from 10 to 20 then BR32 should = FAIR
and If BF32 is greater than 20 then BR32 should = POOR
Here's what I have in cell BF32 -
=IF(BF32="","",IF(BF32<10,"GOOD",IF(BF32>10<20,"FAIR","POOR"))) I can get
GOOG and POOR but not FAIR. What is wrong with my formula?

 

[John C]

Change the IF(BF32>10<20,....
to
IF(AND(BF32>10,BF32<20),....

Hope this helps.