Forum home » Delegate support and help forum » Microsoft Excel Training and help » If statements
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
If statements
Resolved · Low Priority · Version 2007
Reply Wed 22 Apr 2009, 16:00Delegate Stephen said...
Stephen has attended:
Excel Advanced course
If statements
what is the maimum number of nested if functions in 1 formula
For upcoming training course dates see: Pricing & availability
RE: If statements
Hi Stephen. The maximum number is 7.
Hope this helps,
Anthony
RE: If statements
Hi Stephen
The Pre-2007 Excel limit for nested IF statements was 7.
With Excel 2007 the limit has been raised to 64 nested IF statements.
Although the limit is so large, I feel from experience that if your Nested IF statement is over 7 then you need to reconsider the statement or find an easier way of looking for the data.
Regards
Carlos
RE: If statements
Ha! Thanks Carlos, I should have know you'd know that!
Anthony
Reply Tue 28 Apr 2009, 09:53Delegate Simon said...
RE: If statements
Speaking from recent experience, by the time you get up to the region of 7 nested IF
|