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

IF function

ResolvedVersion 2003

Fri 4 Apr 2008, 14:04 Delegate Usman said...

Usman has attended:
Excel Advanced course

IF function

How to formulate in cells

Sat 5 Apr 2008, 04:53 Trainer Nicole said...

RE: IF function

Hi Usman,

I hope you enjoyed your Excel training. Thank you for your question.

The IF function allows Excel to display different answers dependant on certain criteria being met or not met (for example to show whether a student has passed or failed an exam).

To create the formula, you click in the cell where you want the answer to appear and use the Insert Function button (fx) to choose the If function.

In the If function dialogue box you have 3 separate areas

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Create Equations in Excel 2010

Here's how to create basic mathematical
equations in your Excel 2010 worksheet.

1) On the Ribbon, click the Insert tab
2) In the Symbols group, click the arrow next to Equation
3) Select from the equations and the equation will be inserted in a text box

Or you can create your own equation:

1) Insert and select the text box
2) On the Ribbon, click the Insert tab
3) In the Symbols group, click Equation
4) The Equation Tools Design Ribbon will now be displayed

View all Excel hints and tips

IF function

IF function

RE: IF function

Excel articles

Excel tip:

Create Equations in Excel 2010