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?
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