+ Reply to Thread
Results 1 to 3 of 3

Too Many Nested IF Statements -Another Solution?

  1. #1
    Registered User
    Join Date
    07-18-2012
    Location
    Midlothian
    MS-Off Ver
    Excel 2010
    Posts
    2

    Too Many Nested IF Statements -Another Solution?

    I am using Excel 2010 and I thought you could have up to 64 levels of nested IFs statements vs. the previous Excel versions that only allowed 7. I would never nest that many but I have 8 statements that need nesting and I get rejected when I try to add the 8th. Not sure why since it should now allow 64 and my file is saved in the 2010 format.

    Anyway -- can someone help me understand why 2010 is not accepting my 8th statement? OR if you review the formula - how I might approach this differently. Using Lookups, Match and other functions don't seem to lend themselves to what I am trying to do. I am trying to look at a series of cells on the same row and return the value from that series that meet the criteria. Here is the formula. It's the last If statement that causes the errror. Any suggestions are appeciated.

    IF(ISERROR(Y2)," ",IF(Y2="Timing","Timing",IF(ISERROR(Z2)," ",IF(Z2="X","X",IF(AA2="NSF","NSF",IF(AA2="NSF Bank","NSF Bank",IF(ISERROR(AB2)," ",IF(AB2=I2,"Pr Mth Clrd",if(ac2="See Rec Item Sort","See Rec Item Sort,"")))))))))
    Last edited by cdesoi; 07-18-2012 at 01:01 PM.

  2. #2
    Forum Contributor
    Join Date
    08-22-2011
    Location
    Texas, United States
    MS-Off Ver
    Excel 2007 and 2010
    Posts
    516

    Re: Too Many Nested IF Statements -Another Solution?

    well the first thing you can do is remove all of the IF(ISERERROR statments and replace them with IFERROR, that way only one IF statement will be needed for each of these instade of two. This May solve your problem

  3. #3
    Registered User
    Join Date
    07-18-2012
    Location
    Midlothian
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Too Many Nested IF Statements -Another Solution?

    Thanks! I actually figured this out and it was the same theory. I cleaned up the formulas in the columns it was reading so I didn't need the ISERROR statements at all. Then it worked. Your way would have too because it got my nested statements down to 5.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1