Oops!

Gord Dibben is correct. You need to enclose text that you want to display
in double quotes.

Try this:

=IF(Q13="","",IF(Q13<=0.1,"good",IF(AND(Q130.1,Q1 3<0.2),"FAIR","POOR")))

(Notice that I also included values that are exactly 10%--Everything less
than or equal to 10% will return GOOD)

Sorry for the mistake,

Conan


"Conan Kelly" wrote in message
...
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