Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
nesting issue
Hmmm what do I do with this error I am getting? Im using Excel '07 and saved
as marco enabled workbook. The specified formula cannot be entered because it uses more levels of nesting than are allowed in the current file format. I'm using the following formula to look up the amount of an item used by lot numder across 6 work sheets. I am simply adding the next formula in the false part of the statement. =IF(AND(C43='[Stuffing Time Sheet A.xls]sheet5'!$J$5,A43='[Stuffing Time Sheet A.xls]sheet5'!$B$4),IF(ISERROR(VLOOKUP(R52,'[Stuffing Time Sheet A.xls]sheet5'!$I$7:$J$17,2,FALSE))," ",(VLOOKUP(R52,'[Stuffing Time Sheet A.xls]sheet5'!$I$7:$J$17,2,FALSE)))," ") I need this go across sheet1 thru sheet 6, any ideas? thank you in advance!!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
nesting issue
Nested if statements are limited to 7 levels. In order to evaluate more than
that, you would normally use more than one formula and then use a formula which would evaluate the answers of all the other formulas. Mike F "Lost" wrote in message ... Hmmm what do I do with this error I am getting? Im using Excel '07 and saved as marco enabled workbook. The specified formula cannot be entered because it uses more levels of nesting than are allowed in the current file format. I'm using the following formula to look up the amount of an item used by lot numder across 6 work sheets. I am simply adding the next formula in the false part of the statement. =IF(AND(C43='[Stuffing Time Sheet A.xls]sheet5'!$J$5,A43='[Stuffing Time Sheet A.xls]sheet5'!$B$4),IF(ISERROR(VLOOKUP(R52,'[Stuffing Time Sheet A.xls]sheet5'!$I$7:$J$17,2,FALSE))," ",(VLOOKUP(R52,'[Stuffing Time Sheet A.xls]sheet5'!$I$7:$J$17,2,FALSE)))," ") I need this go across sheet1 thru sheet 6, any ideas? thank you in advance!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
nesting ?? | Excel Worksheet Functions | |||
Nesting If and And | Excel Worksheet Functions | |||
Another nesting issue | Excel Discussion (Misc queries) | |||
nesting issue in functions | Excel Worksheet Functions | |||
nesting sum if and | Excel Worksheet Functions |