| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested Functions Limit
I was wondering if there is a way to re-write the formula below or nest more
than 7 IF scenarios. I need to be able to check for several scenarios or more than 7. Is this possible? =IF(ISNUMBER(SEARCH("TIER 1",$C3,1)),"TIER 1",IF(ISNUMBER(SEARCH("TIER 2",$C3,1)),"TIER 2",IF(ISNUMBER(SEARCH("TIER 3",$C3,1)),"TIER 3",IF(ISNUMBER(SEARCH("Chicago",$C3,1)),"Chicago", IF(ISNUMBER(SEARCH("St. Louis",$C3,1)),"St. Louis","Not Valid"))))) -- Thank you for your help and support |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to get around limit of 7 nested functions | Excel Worksheet Functions | |||
| Limit to nested IF(ISNUMBER(SEARCH)) functions? | Excel Worksheet Functions | |||
| Nested If Limit | Excel Worksheet Functions | |||
| limit of 7 nested functions? | Excel Worksheet Functions | |||
| Nested IF limit or Open parentheses limit | Excel Discussion (Misc queries) | |||
Threaded Mode
