One way:

=IF(Q13="","",IF(Q13<=0.1,"GOOD",IF(Q13<=0.2,"FAIR ","POOR")))

In article ,
Loren wrote:

I want cell S13 to give a certain answer depending on the value in cell Q13 -
I.E.
IF cell Q13 value is .1 or less then S13 = GOOD IF cell Q13 value is .1
to .2 then cell S13 = FAIR and if cell Q13 value is greater than .2 cell S13
= POOR. Here's the equation I have now and all cell S13 will tell me is #NAME?
=IF(Q13="","",IF(Q13<0.1,(good),IF(Q130.1<0.2,(FA IR),(POOR))))