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