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

Nested IF function

ResolvedVersion 2007

Tue 15 Sep 2009, 16:28 Delegate William said...

William has attended:
Excel Intermediate course

Nested IF function

Don't know quite how they work and also about further logical function

Wed 16 Sep 2009, 16:19 Trainer Simon said...

RE: nested IF function

Hi William,

Thank you for your question.

A Nested If is used if you want to test a cell against multiple conditions.

An IF function only allows you to test a cell using one condition.

Here is an example:

=if(c5>100,50,if(c5>30,20,10))

I hope this answers your question.

Regards

Simon

Wed 23 Sep 2009: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Transpose text

You can transpose any range of cells, turning the columns into rows and the rows into columns. Just follow these steps:

Select the range.

Click the Copy button on the Standard toolbar to copy it to the Clipboard.

Select a cell outside of the range you copied.

Select Paste Special from the Edit menu.

In the Paste Special dialog box, click Transpose, then OK.

View all Excel hints and tips

Nested IF function

Nested IF function

RE: nested IF function

Excel articles

Excel tip:

Transpose text