| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Exceeding Limit on Nested IF Statements
I am converting a budget spreadsheet from Lotus 1-2-3 to Excel. Excel's
limit on nested IF statements is creating my biggest challenge. I have budget and actual columns next to one another for each month. A Lotus formula reads from a cell identifying the current month that requires 12 if statements. [i.e. (If month = January, add one column, if february add two columns, ...if December add 12 columns.)] What is my Excel alternative to nested if's in this situation? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested If Exceeding 7 Calculations | Excel Discussion (Misc queries) | |||
| exceeding columns limit | Excel Discussion (Misc queries) | |||
| Exceeding the limit for Nested IFs | Excel Worksheet Functions | |||
| How to add more than 7 if nested statements. 7 is the limit. | Excel Discussion (Misc queries) | |||
| Employing constant arrays to limit nested IF statements. | Excel Worksheet Functions | |||
Threaded Mode
