+ Reply to Thread
Results 1 to 7 of 7

too much nesting

  1. 07-17-2013, 02:30 AM #1
    sansan_ooi is offline
    Registered User
    Join Date
    07-17-2013
    Location
    penang, malaysia
    MS-Off Ver
    Excel 2003
    Posts
    3

    Post too much nesting

    I'm getting an error that says "the specified formula cannot be entered because it uses more levels of nesting than are allowed in the current file format".

    Is there any way around this? I need the entire formula I'm entering into the cell.

    This is my formula that I need to entering into the cell.


    =IF(AF2="30 Days",(EOMONTH(AE2,1)+20),(IF(AF2="45 Days",(EOMONTH(AE2,1)+30),(IF(AF2="60 Days",(EOMONTH(AE2,2)+20),(IF(AF2="90 Days",(EOMONTH(AE2,3)+20),(IF(AF2="Advance",(AE22+0),(IF(AF2="Net 140Days",(AE2+14),(IF(AF="Net 30 Days",(AE2+30),(IF(AF2="Net 45 Days",(AE2+45),(IF(AF2="Net 60 Days",(AE2+60),(IF(AF2="Net 90 Days",(AE2+90),(IF(AF="COD",(AE2+0),(IF(AF2="COD-E",(AE2+0),0))))))))))))))))))))))

    Thanks.
    Reply With QuoteRegister To Reply
  2. 07-17-2013, 02:47 AM #2
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: too much nesting

    As your profile says, you use Excel 2003. So in this case you have a limit of 7 IF...

    There are ways to get over it. Some are described in this link. This does not mean that there are not other ways.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.
    Reply With QuoteRegister To Reply
  3. 07-17-2013, 03:10 AM #3
    sansan_ooi is offline
    Registered User
    Join Date
    07-17-2013
    Location
    penang, malaysia
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: too much nesting

    Thanks for reply me...

    I have try using at Excel 2007, but the error still happened.
    Reply With QuoteRegister To Reply
  4. 07-17-2013, 03:21 AM #4
    humdingaling is offline
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: too much nesting

    dont know if this is causing error but
    AF="Net 30 Days"
    AF="COD"
    assume these should be AF2


    also IF(AF2="Advance",(AE22+0) should be AE2 i believe
    Last edited by humdingaling; 07-17-2013 at 03:25 AM.
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
    Reply With QuoteRegister To Reply
  5. 07-17-2013, 03:32 AM #5
    sansan_ooi is offline
    Registered User
    Join Date
    07-17-2013
    Location
    penang, malaysia
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: too much nesting

    Thanks, I have solve it. That is because of my mistyping when I type in the formula. Anyway, thank for help me to solve this problem.
    Reply With QuoteRegister To Reply
  6. 07-17-2013, 03:36 AM #6
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: too much nesting

    You are welcome and thanks for the feed back.

    As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thank you.
    Reply With QuoteRegister To Reply
  7. 07-17-2013, 03:37 AM #7
    humdingaling is offline
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: too much nesting

    while your at it
    AF2="Net 140Days"
    14 i think
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. IF and AND nesting
    By Perran in forum Excel General
    Replies: 5
    Last Post: 04-28-2012, 09:14 PM
  2. If/Then Nesting AND/OR
    By artiststevens in forum Excel General
    Replies: 2
    Last Post: 01-01-2011, 05:56 PM
  3. IF nesting
    By mojobaabby in forum Excel General
    Replies: 8
    Last Post: 09-05-2010, 07:03 AM
  4. [SOLVED] IF - Nesting... almost got it - need a bit of help
    By Bill Kuunders in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-06-2005, 05:05 PM
  5. [SOLVED] IF - Nesting... almost got it - need a bit of help
    By Bill Kuunders in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 05:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1