Home |
Search |
Today's Posts |
#1
|
|||
|
|||
the specified form cannot be entered because it uses more levels of nesting
Hello,
I need help!!!! I have a lot of cases that I want to put in one query! But i I keep getting the following error message: "The specified formula can not be entered because it uses more level of nesting than are allowed in current file format." Here are my cases: "" and "" = "" I and O = ok O and I = OK ok and ok = ok I,O and I,O = ok O and O = I-F I and I = O-F I,O and O = I-F I,O and I = O-F O and I,O = I-F I and I,O = O-F "" and I = O-F "" and O = I-F I and "" = O-F O and "" = I-F And the formula looks like this: =IF(OR(AND(Kopie!F7="I";Kopie_T!F7="O");AND(Kopie! F7="O";Kopie_T!F7="I");AND(Kopie!F7="I, O";Kopie_T!F7="I, O");AND(Kopie!F7="OK";Kopie_T!F7="OK"));"OK";IF(AN D(Kopie!F7="";Kopie_T!F7="");"";IF(Kopie!F7="";Kop ie_T!F7&"-2";IF(Kopie_T!F7="";Kopie!F7&"-1";IF(AND(Kopie!F7="I, O";Kopie_T!F7="I");Kopie!F7;IF(AND(Kopie!F7="I";OR (Kopie_T!F7="I, O";Kopie_T!F7="I"));"O-F";IF(AND(Kopie!F7="O";OR(Kopie_T!F7="I, O";Kopie_T!F7="O"));"I-F";"I, O-1"))))))) could someone please help me? THX!!!!!!!!!!!! Last edited by sixm-trinity : August 16th 12 at 08:05 PM |
#2
|
|||
|
|||
Quote:
Could you post an example workbook? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
the specified form cannot be entered because it uses more levelsof nesting
I have a lot of cases that I want to put in one query!
Here are my cases: "" and "" = "" I and O = ok O and I = OK ok and ok = ok I,O and I,O = ok O and O = I-F I and I = O-F I,O and O = I-F I,O and I = O-F I and I,O = O-F "" and I = O-F "" and O = I-F I and "" = O-F O and "" = I-F Concatenation can simplify the problem to a lookup, rather than a logic formula. I set up a lookup table in columns F:I using your cases. Then with input values in A1 and B1 I put the lookup calculation in C1. The CSV file is below. --------------- cut here --------------- I,O,"=VLOOKUP(A1&"" xxx ""&B1,F:I,4,FALSE)",,,,,, ,,,,,"=G3&"" xxx ""&H3",,,"=""""" ,,,,,"=G4&"" xxx ""&H4",I,O,ok ,,,,,"=G5&"" xxx ""&H5",O,I,OK ,,,,,"=G6&"" xxx ""&H6",ok,ok,ok ,,,,,"=G7&"" xxx ""&H7","I,O","I,O",ok ,,,,,"=G8&"" xxx ""&H8",O,O,I-F ,,,,,"=G9&"" xxx ""&H9",I,O,O-F ,,,,,"=G10&"" xxx ""&H10","I,O",O,I-F ,,,,,"=G11&"" xxx ""&H11","I,O",I,O-F ,,,,,"=G12&"" xxx ""&H12",O,"I,O",I-F ,,,,,"=G13&"" xxx ""&H13",I,"I,O",O-F ,,,,,"=G14&"" xxx ""&H14",,I,O-F ,,,,,"=G15&"" xxx ""&H15",,O,I-F ,,,,,"=G16&"" xxx ""&H16",I,,O-F ,,,,,"=G17&"" xxx ""&H17",O,,I-F |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - exceed nesting levels | Excel Discussion (Misc queries) | |||
Maxing out nesting levels limitation of IF function | Excel Worksheet Functions | |||
Can I increase the limit of of nesting levels allowed in a file? | Excel Programming | |||
30 levels of nesting excel | Excel Worksheet Functions | |||
too many levels of nesting | Excel Worksheet Functions |