Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

nested ifs

ResolvedVersion 2003

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

Fri 4 Nov 2011: Automatically marked as resolved.

Excel tip:

Manually wrapping text

To manually wrap text, use the shortcut key Alt+Enter.

To cancel manual text wrapping, simply delete the new line.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.