Won't give correct answer
=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 |
Won't give correct answer
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? |
Won't give correct answer
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 |
Won't give correct answer
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 |
Won't give correct answer
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 |
All times are GMT +1. The time now is 04:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com