The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Nested IF statements

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Nested IF statements

Resolved · Medium Priority · Version 2007

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

Nested IF statements

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

For upcoming training course dates see: Pricing & availability

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

Excel articles

· How To Share Files In Excel 2010
· How To Use The Page Layout Features In Excel 2007 And Excel 2010
· So Can You Really Sort On Colours In Excel 2007?
· Excel in the Home Office
· Simple Ways To Customise Excel

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

Excel tip:

Multiple Lines of Text in a Cell

As an alternative to the Text Wrapping facility, type a word or two, press Alt+Enter to get a new line, type more text, and continue the process for as many lines as you need. Enter as normal when you have finished.

The line break is not affected by changing the column width, as text wrapping. To remove this you must edit the cell and remove the invisible character and replace with a normal space.

View all Excel hints and tips

Macro

» Forum post: Macro

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions