Wrong Answer
 

I'm putting this function in cell S13:

=IF(Q13="","",IF(Q13<0.1,good,IF(Q130.1<0.2,FAIR, POOR)))
I want GOOD for anything from 0 to 10%, FAIR for anything over 10% up to
20% and POOR for anything above 20%. What am I doing wrong?

No matter what I put in cell Q13, what shows up in cell S13 is - #NAME
- Why?
--
Loren

Wrong Answer
 

The output messages need to be enclosed in quotes...

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

--
HTH...

Jim Thomlinson


"Loren" wrote:

I'm putting this function in cell S13:

=IF(Q13="","",IF(Q13<0.1,good,IF(Q130.1<0.2,FAIR, POOR)))
I want GOOD for anything from 0 to 10%, FAIR for anything over 10% up to
20% and POOR for anything above 20%. What am I doing wrong?

No matter what I put in cell Q13, what shows up in cell S13 is - #NAME
- Why?
--
Loren

Wrong Answer
 

Try this:

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

Text needs to be enclosed in "quotes", otherwise, Excel will look for named
ranges called GOOD, FAIR and POOR. Also, on your 3rd IF statement, you don't
need to specify Q13 0.1 since this IF statement is only reached if Q31 is
not less than 0.1.

HTH,
Elkar


"Loren" wrote:

I'm putting this function in cell S13:

=IF(Q13="","",IF(Q13<0.1,good,IF(Q130.1<0.2,FAIR, POOR)))
I want GOOD for anything from 0 to 10%, FAIR for anything over 10% up to
20% and POOR for anything above 20%. What am I doing wrong?

No matter what I put in cell Q13, what shows up in cell S13 is - #NAME
- Why?
--
Loren

Wrong Answer
 

Is the issue that XL thinks GOOD is a named range, or that it is a function?
--
Brevity is the soul of wit.


"Elkar" wrote:

Try this:

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

Text needs to be enclosed in "quotes", otherwise, Excel will look for named
ranges called GOOD, FAIR and POOR. Also, on your 3rd IF statement, you don't
need to specify Q13 0.1 since this IF statement is only reached if Q31 is
not less than 0.1.

HTH,
Elkar


"Loren" wrote:

I'm putting this function in cell S13:

=IF(Q13="","",IF(Q13<0.1,good,IF(Q130.1<0.2,FAIR, POOR)))
I want GOOD for anything from 0 to 10%, FAIR for anything over 10% up to
20% and POOR for anything above 20%. What am I doing wrong?

No matter what I put in cell Q13, what shows up in cell S13 is - #NAME
- Why?
--
Loren

Wrong Answer
 

GOOD would be a named range. GOOD() would be a function.

"Dave F" wrote:

Is the issue that XL thinks GOOD is a named range, or that it is a function?
--
Brevity is the soul of wit.


"Elkar" wrote:

Try this:

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

Text needs to be enclosed in "quotes", otherwise, Excel will look for named
ranges called GOOD, FAIR and POOR. Also, on your 3rd IF statement, you don't
need to specify Q13 0.1 since this IF statement is only reached if Q31 is
not less than 0.1.

HTH,
Elkar


"Loren" wrote:

I'm putting this function in cell S13:

=IF(Q13="","",IF(Q13<0.1,good,IF(Q130.1<0.2,FAIR, POOR)))
I want GOOD for anything from 0 to 10%, FAIR for anything over 10% up to
20% and POOR for anything above 20%. What am I doing wrong?

No matter what I put in cell Q13, what shows up in cell S13 is - #NAME
- Why?
--
Loren

Wrong Answer
 

Ah, right.
--
Brevity is the soul of wit.


"Elkar" wrote:

GOOD would be a named range. GOOD() would be a function.

"Dave F" wrote:

Is the issue that XL thinks GOOD is a named range, or that it is a function?
--
Brevity is the soul of wit.


"Elkar" wrote:

Try this:

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

Text needs to be enclosed in "quotes", otherwise, Excel will look for named
ranges called GOOD, FAIR and POOR. Also, on your 3rd IF statement, you don't
need to specify Q13 0.1 since this IF statement is only reached if Q31 is
not less than 0.1.

HTH,
Elkar


"Loren" wrote:

I'm putting this function in cell S13:

=IF(Q13="","",IF(Q13<0.1,good,IF(Q130.1<0.2,FAIR, POOR)))
I want GOOD for anything from 0 to 10%, FAIR for anything over 10% up to
20% and POOR for anything above 20%. What am I doing wrong?

No matter what I put in cell Q13, what shows up in cell S13 is - #NAME
- Why?
--
Loren