Nested IF statements

The UK's most regular instructor-led training courses.
Training information: excel-xp-training · Excel course · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Medium Priority · Version 2007

2 posts

ReplyWed 1 Jul 2009, 16:19Delegate Martin said...

Martin has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Excel Advanced course

Nested IF statements

How many nested IF statements can be written using MS Excel 2007? Is it seven or now unlimited?

Version	Date	Location	Places available	Book	Next place rate (£)
Excel VBA Intro Intermediate 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Mon 22 + Tue 23 Mar 2010	Bloomsbury	0	FULL
2007	Tue 6 + Wed 7 Apr 2010	Bloomsbury	4		£470	£475
2003	Wed 7 + Thu 8 Apr 2010	Southwark	7		£445	£450
2007	Thu 15 + Fri 16 Apr 2010	Bloomsbury	0	FULL
2003	Wed 21 + Thu 22 Apr 2010	Bloomsbury	7		£445	£450
2007	Wed 28 + Thu 29 Apr 2010	Bloomsbury	6		£445	£450
Full Schedule: See all 35 Excel VBA Intro Intermediate course dates. Bookings currently available until 22nd December 2010.

2,024 posts

ReplyThu 2 Jul 2009, 09:45Trainer Amanda said...

RE: Nested IF statements

Hello Martin

Thank you for your question.

According to the Microsoft web site, the limit is 64 (extended from 7 in the previous version of Excel):

"Up to 64 IF functions can be nested as value_if_true and value_if_false arguments to construct more elaborate tests."

If you are going to be sending or sharing spreadsheets with others that are still using the previous version, this is something to bear in mind.

Also Microsoft suggest:

"Alternatively, to test many conditions, consider using the LOOKUP, VLOOKUP, HLOOKUP, or CHOOSE functions."

http://office.microsoft.com/en-us/excel/HP100698291033.aspx?pid=CH100645131033

Kind regards
Amanda

· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· A Blinking Good Excel Tip
· Correct In, Garbage Out
· Why Should I Learn Visual Basic in Excel?
· Flexible uses for Excel at Home

Please browse our web site to find out more about
excel-xp-training and other Microsoft training courses.