Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A ? for our Excel Guru's and MVPs | Excel Discussion (Misc queries) | |||
=D6-E6. Answer in F6. I want answer in F6 only if value in E6? | Charts and Charting in Excel | |||
What if I want the answer to be in Dollars or Percentage. | Excel Worksheet Functions | |||
Formula not Return Required Answer Q | Excel Worksheet Functions | |||
Recalculating Formula - Getting the wrong answers | Excel Discussion (Misc queries) |