| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Nested IF statements
I am trying to convert an old Lotus 1-2-3 spreadsheet into Excel. I have
several cells that contain multiple nested IF statements. I understand from the documentation that there is a limitation in Excel that says that you can only have 7 levels of nested IF statements. I have a need to go as many as 18 levels of nested IF statements. Is there any way to cajole Excel into not choking on this nesting? There are so many things that Excel does better than Lotus 1-2-3, but this is one big negative for Excel. Thanks for any input you can provide. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Employing constant arrays to limit nested IF statements. | Excel Worksheet Functions | |||
| 7+ nested if statement? | Excel Worksheet Functions | |||
| Problem with data using IF and Nested IF statements possibly??? | Excel Discussion (Misc queries) | |||
| nested statements | New Users to Excel | |||
| Do I need nested IF statements? | Excel Worksheet Functions | |||
Threaded Mode
