Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 2
Default 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   Report Post  
Senior Member
 
Posts: 663
Default

Quote:
Originally Posted by sixm-trinity View Post
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?
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 153
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel - exceed nesting levels Jamie Excel Discussion (Misc queries) 2 January 12th 10 08:56 AM
Maxing out nesting levels limitation of IF function Sergei Excel Worksheet Functions 3 September 25th 08 05:23 PM
Can I increase the limit of of nesting levels allowed in a file? Yardlad Excel Programming 2 July 30th 08 12:30 AM
30 levels of nesting excel prokopof Excel Worksheet Functions 1 April 2nd 08 09:57 PM
too many levels of nesting Rookie Excel Worksheet Functions 7 July 23rd 07 09:49 AM


All times are GMT +1. The time now is 06:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"