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))))
--
Loren

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.

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

"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))))
--
Loren

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))))

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

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

"roadkill" wrote:

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

"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))))
--
Loren

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




In article .com,
"DaveO" wrote:

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.

IF cell Q13 value is .1 or less then S13 = GOOD
F cell Q13 value is .1 to .2 then cell S13 = FAIR
if cell Q13 value is greater than .2 cell S13 = POOR.

=IF(ISNUMBER(Q13)=FALSE,"NEXT VALUE
PLS!",if(Q130.2,"POOR",IF(Q130.1,"FAIR",IF(Q13<= 0.1,"GOOD"))))

regards...
--
*****
birds of the same feather flock together..



"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))))
--
Loren