| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - exceed nesting levels
I am trying to create an "if" formula to check cells in a particular column
for different texts, but it only lets me add 7 before getting an error that I have exceeded the limit for nesting in the current file format. How do I work around this? =IF(D4378="LUNCH/OFFICER",O4378,IF(D4378="INFORMATION",O4378,IF(D43 78="BUSY",O4378,IF(D4378="DETAIL",O4378,IF(D4378=" END OF DUTY",O4378,IF(D4378="EQUIPMENT",O4378,IF(D4378="F UEL",O4378,IF(D4378="LIDAR CALIBRATION",O4378,"")))))))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maxing out nesting levels limitation of IF function | Excel Worksheet Functions | |||
| 30 levels of nesting excel | Excel Worksheet Functions | |||
| Can exceed 65,000rows in Excel? | Excel Discussion (Misc queries) | |||
| too many levels of nesting | Excel Worksheet Functions | |||
| Excel columns do they exceed IV? | Excel Worksheet Functions | |||
Threaded Mode
