IF Function not working

[Guest]

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(Q13>0.1<0.2,(FAIR),(POOR))))

 

[DaveO]

Put quotation marks around the words good, fair, and poor. This is
because you are asking Excel to enter a text phrase in the cell. Right
now Excel is looking for a named range called good, fair, and poor,
and responding with #NAME because it can't find them.

 

[Guest]

Try putting double quotes around "good", "FAIR", and "POOR".
Will

 

[JE McGimpsey]

One way:

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

 

[DaveO]

My apologies, some modification to your formula is required as well.
Please try this one:
=IF(Q13<=0.1,"good",IF(AND(Q13>0.1,Q13<0.2),"fair","poor"))

 

[Guest]

Sorry - I missed something else. Suggest you change "Q13>0.1<0.2" to
"and(Q13>0.1,Q13<0.2)".
Will

 

[JE McGimpsey]

Note that simply using quotation marks won't solve the problem, as the
syntax in the third conditional is wrong (i.e., Q13>0.1<0.2)

 

[Guest]

=IF(ISNUMBER(Q13)=FALSE,"NEXT VALUE
PLS!",if(Q13>0.2,"POOR",IF(Q13>0.1,"FAIR",IF(Q13<=0.1,"GOOD"))))

regards...