the specified form cannot be entered because it uses more levels of nesting

[sixm-trinity]

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 o
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(AND(Kopie!F7="";Kopie_T!F7="");"";IF(Kopie!F7="";Kopie_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!!!!!!!!!!!

 

[Spencer101]

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 o
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(AND(Kopie!F7="";Kopie_T!F7="");"";IF(Kopie!F7="";Kopie_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

 

[zvkmpw]

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