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!!!!!!!!!!!!

What version of excel are you using?

Could you post an example workbook?

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