| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nesting Limit 2007
I was under the impression that excel 2007 allowed more than 7 nested
finctions or up to 64, but I continue to get an error that says "..........uses more level of functions than are allowed in the current format." The formula is below. =IF(MID($B2,39,3)="Eye","RM",IF(RIGHT($B2,2)="RM", "RM",IF(ISNUMBER(SEARCH("Gum",$B2,1)),"RON",IF(ISN UMBER(SEARCH("EyeWonder",$B2,1)),"RM",IF(ISNUMBER( SEARCH("Video",$B2,1)),"RM",IF(ISNUMBER(SEARCH("Ta rget",$B2,1)),"RON",IF(ISNUMBER(SEARCH("RM",$B2,1) ),"RM","Not Valid"))))))) -- Thank you for your help and support |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 problem nesting IF & AND | Excel Worksheet Functions | |||
| IF condition Nesting limit error | New Users to Excel | |||
| IF condition Nesting limit error | New Users to Excel | |||
| IF condition Nesting limit error | New Users to Excel | |||
| Have I exceeded nesting limit | Excel Worksheet Functions | |||
Threaded Mode
