98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » If statements
If statements
Resolved · Low Priority · Version 2007
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
Wed 22 Apr 2009, 16:38Trainer Anthony said...
RE: If statements
Hi Stephen. The maximum number is 7.
Hope this helps,
Anthony
Wed 22 Apr 2009, 16:40Trainer Carlos said...
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
Wed 22 Apr 2009, 17:01Trainer Anthony said...
RE: If statements
Ha! Thanks Carlos, I should have know you'd know that!
Anthony
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. |
Excel tip:Add a € to your cellsIf you need to add a € symbol to your Excel sheet - hold down the key Alt Gr and 4. |
