Loren,

You need to do 2 separate comparisons, you can't do both in one expression.

Try changing this:
=IF(Q13="","",IF(Q13<0.1,(good),IF(Q130.1<0.2,(FA IR),(POOR))))

To this:
=IF(Q13="","",IF(Q13<0.1,(good),IF(AND(Q130.1,Q13 <0.2),(FAIR),(POOR))))

Also keep in mind that you are including values below 10% and values between
10% and 20%, but you do not include values of exactly 10%. With this
formula, 10% will return POOR while 9.999999% will return GOOD and
10.000000001% will return FAIR.

you might consider changing either your first < or to <= and =
respectively (only change one, not both).

I hope this helps,

Conan Kelly




"Loren" wrote in message
...
=IF(Q13="","",IF(Q13<0.1,(good),IF(Q130.1<0.2,(FA IR),(POOR))))

Cell Q13 = .33 but what shows up in this cell is #NAME? What
am
I doing wrong?
--
Loren