Forum home » Delegate support and help forum » Microsoft Excel Training and help » What is a nested if?

What is a nested if?

ResolvedVersion 2007

Thu 19 Mar 2009, 16:26 Delegate Paul said...

Paul has attended:
Excel Intermediate course

What is a nested if?

Mon 23 Mar 2009, 10:28 Trainer Simon said...

RE: What is a nested if?

Hi Paul,

Thank you for your question.

A Nested If is used when you have more than one condition to satisfy in a formula. You can nest up to 7 levels.

Nested If's are used to test multiple conditions each having their own True answer and finally ending up with one false answer that is used for all the other values that are not met by the conditions you have specified.

I hope this answers your question.

Regards

Simon

Mon 30 Mar 2009: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

The dual nature of toolbar buttons

Many toolbar buttons are dual purpose, though the two purposes are often linked in some way. For example, Align Left aligns a cell's contents to the left of the cell. However, hold down Shift and press the Align Left button: Excel aligns the cell contents to the right.
You may respond: So what? Well, you can reduce the number of buttons on your toolbar to make your screen less cluttered and allow more room for, perhaps, some of your own commands. After all, what's the point of an Align Right button when Shift+Align Left does the same thing?

View all Excel hints and tips

What is a nested if?

What is a nested if?

RE: What is a nested if?

Excel articles

Excel tip:

The dual nature of toolbar buttons