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