nested if

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Nested if

Nested if

resolvedResolved · Low Priority · Version 2003

Dragana has attended:
Excel Advanced course

Nested if

What is the limit of ifs in a nested if

RE: Nested if

Hello Dragan
Thank you for your question

You can have up to 7 nested IFs.

If this resolves your question, please mark it as resolved. If not, please reply with more information.

Kind regards
Cress

Tue 3 Mar 2009: Automatically marked as resolved.


 

Excel tip:

Quick Absolute Cell References

When entering cell references in a formula you probably click the cell, or you may type in the cell reference. If you require any of the 4 variations, press the F4 key now before you press Enter to toggle around the relative and absolute entries ($signs).

Note that the F4 key outside of editing a formula is the Repeat key to repeat a previous action.

View all Excel hints and tips


Server loaded in 0.08 secs.