| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested IF too long - other suggestions?
Our timesheet template asks for the Employee name in a pop-up dialog box. The
result assigns a number to a cell. That result assigns the employee name, title, and employment status to different cells in the sheet using nested IF formulas. For some reason I cannot add a 10th, 11th, etc level to the nest even though Help says 64 levels are possible. =IF(R1=1,Q1,IF(R1=2,Q2,IF(R1=3,Q3,IF(R1=4,Q4,IF(R1 =5,Q5,IF(R1=6,Q6,IF(R1=7,Q7,IF(R1=8,Q8,Q9)))))))) Any suggestions? Can I use LOOKUP? If so how? Or is there something else?? Thanks!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Suggestions??? | Excel Discussion (Misc queries) | |||
| Clearing cells takes long, long time | Excel Discussion (Misc queries) | |||
| any suggestions? | Excel Discussion (Misc queries) | |||
| Need your suggestions | Excel Worksheet Functions | |||
| Suggestions Please | Excel Discussion (Misc queries) | |||
Threaded Mode
