| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula not working
This formula doesn't work:
=IF(I43=0-10,"0-10",IF(I43=11-20,"11-20",IF(I43=21-35,"21-35",IF(I43=36-49,"36-49","50+")))) In I43 the number is 41, therefore in I44, where I have this formula, it should be giving 36-49, not 50+. It should only give 50+ when it doesn't fit into any of the other IF statements. What have I done wrong? Connie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to find the working days difference between to dates? | Excel Discussion (Misc queries) | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Array Formula Not Working with Range with Formulas | Excel Discussion (Misc queries) | |||
| VLOOKUP & Dates: Why is this Formula working? | Excel Worksheet Functions | |||
| Formula entered not working | Excel Discussion (Misc queries) | |||
Threaded Mode
