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