Too Many Nested IF Statements -Another Solution?

1. 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,"")))))))))

2. 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. 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.

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

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