Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
is there a limit to the number of nests you can have in a nested
IF(ISNUMBER(SEARCH)) functions? For example, I have one that works properly with 6; for example: =IF(ISNUMBER(SEARCH("jon",AC2)),"jon",IF(ISNUMBER( SEARCH("bill",AC2)),"bill",IF(ISNUMBER(SEARCH("tom ",AC2)),"tom",IF(ISNUMBER(SEARCH("joe",AC2)),"joe" ,IF(ISNUMBER(SEARCH("rob",AC2)),"rob",IF(ISNUMBER( SEARCH("ted",AC2)),"ted","")))))) if I add another nest, Excel finds an error with the last search and will not allow it... Thanks in advance for your help, Jonathan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ISNUMBER and IF Functions | Excel Discussion (Misc queries) | |||
Nested If Limit | Excel Worksheet Functions | |||
limit of 7 nested functions? | Excel Worksheet Functions | |||
array functions and ISNUMBER() | Excel Worksheet Functions | |||
Nested IF limit or Open parentheses limit | Excel Discussion (Misc queries) |