How Many Nested IF Functions Can Excel 2010 Handle

**boohah** · 01-28-2010, 08:00 PM

Hi

Just wondering how man nested IF functions excel 2010 can handle in one cell.

Doug

**Richard Buttrey** · 01-28-2010, 08:15 PM

Hi,

I don't think it's any more than the 64 levels you get in 2007. Although if you ever start getting anywhere near that level I'd say you're heading for trouble. Almost certainly there will be a better way of achieving your goal.

HTH

**boohah** · 01-28-2010, 08:28 PM

Hi Richard

Thanks for your reply as it has been most helpful. You have got me wondering though. I use spreadsheets that span over 20,000 rows and hundreds of columns and I have formulas that use the absolute maximum number of IF functions and to be honest they could use more. I keep being told that this is bad practice but in spreadsheets this size, I have found that using VLOOKUP or INDEX and MATCH solutions to be far too intensive on my computer's resources. Even worse it just kills the spreadsheet and locks up my computer. Do you know of an easier way because I would love to hear it.

Doug

**pawanbang** · 01-08-2013, 05:57 PM

Hi

I am trying to put more than 9 nesting with IF but in Excel 2010, it is not accepting. Can you please tell me is there any ways to put more than 9 nesting in single cell.

Pawan

**Richard Buttrey** · 01-08-2013, 06:16 PM

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

The answer is Yes. I believe 64 levels but if you find you're starting to use more than eight or nine then almost certainly there will be a better way.