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 » Nested IFs
Nested IFs
Resolved · Low Priority · Version 2003
Wed 26 Oct 2011, 14:12Delegate Julia said...
Julia has attended:
Excel Advanced course
Nested IFs
We are trying to do a formula that would need 9 nested IFS, however 2003 only allows a maximum of 7, what would be an alternative formula for us to use?
Fri 28 Oct 2011, 16:59Trainer Simon said...
RE: nested IFs
Hi Julia,
Thank you for your question.
You can create the Nested If's in two different formulas and then name each cell containing each formula. Then create a third formula that combines the two.
Please find the following link:
http://www.cpearson.com/excel/nested.htm
Regards
Simon
Fri 4 Nov 2011: Automatically marked as resolved.
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:Convert a column into row quickly in Excel 2010Occasionally you might enter data into Excel vertically and then when you finish realize that actually it would look more clearer if it was represented in a horizontal format. If you follow these simple steps below, you can quickly change the data from going vertically to horizontally and vice versa. |
