=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

good, FAIR and POOR must be enclosed in double quotes.

"good" etc.


Gord Dibben MS Excel MVP

On Fri, 5 Jan 2007 10:34:00 -0800, Loren
wrote:

=IF(Q13="","",IF(Q13<0.1,(good),IF(Q130.1<0.2,(F AIR),(POOR))))

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

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

Your text values need to be enclosed in "quotes". Also, the Q130.1<0.2
should just be Q13<0.2 since this would only be evaluated if Q13<0.1 is
FALSE. Try this:

=IF(Q13="","",IF(Q13<0.1,"(good)",IF(Q13<0.2,"(FAI R)","(POOR)")))

HTH,
Elkar

"Loren" wrote:

=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

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