Before you begin

If a yellow security bar appears at the top of the screen in PowerPoint, click Enable Editing. You need PowerPoint 2010 to view this presentation. If you don’t have PowerPoint 2010, download the PowerPoint Viewer (see the URL in the notes pane).

The IF function: What it is, and how to use it

Microsoft

®

Excel

®

2010 Training

The IF function: What it is, and how to use it

Course contents

• Overview:

True or false

• Lesson:

Includes three instructional movies

• Suggested practice tasks • Test • Quick Reference Card

The IF function: What it is, and how to use it

Overview: True or false

The IF function checks to see if a condition you specify is true, or false. If true, one thing happens; if false, something else happens. For example, if you use the IF function to see if amounts spent are under or over budget, the result for True could be “Within budget,” while the result for False could be “Over budget.” The IF function: What it is, and how to use it

• •

Course goals

Use the IF function.

Use more than one IF function in a formula.

The IF function: What it is, and how to use it

Introduction: The IF function Point to the bottom of the video to see the video controls. Drag or point along the progress bar to move forward or go back.

The IF function: What it is, and how to use it

Add or multiply IF results Point to the bottom of the video to see the video controls. Drag or point along the progress bar to move forward or go back.

The IF function: What it is, and how to use it

Using more than one IF function Point to the bottom of the video to see the video controls. Drag or point along the progress bar to move forward or go back.

The IF function: What it is, and how to use it

Suggestions for practice

1.

2.

3.

4.

5.

Use the IF function to determine whether expenses are within or over budget.

Type the IF formula directly into a cell.

Figure out a shipping expense; figure out salary deductions.

Use more than one IF function (nested functions).

Use a nested IF function to figure out a sales commission, and then figure out salary deductions.

Online practice (requires Excel 2010) The IF function: What it is, and how to use it

Test question 1

The logical_test argument can only return either True or False. (Pick one answer.)

1.

2.

True.

False. The IF function: What it is, and how to use it

Test question 1

The logical_test argument can only return either True or False.

Answer:

1.

True.

The IF function: What it is, and how to use it

Test question 2

In the value_if_true and value_if_false arguments, use quotation marks around numbers. (Pick one answer.)

1.

2.

True.

False. The IF function: What it is, and how to use it

Test question 2

In the value_if_true and value_if_false arguments, use quotation marks around numbers.

Answer:

2.

False.

You use quotation marks around text only within these arguments.

The IF function: What it is, and how to use it

Test question 3

How many possible outcomes are there with a single IF statement? (Pick one answer.)

1.

2.

3.

One.

Two.

Three.

The IF function: What it is, and how to use it

Test question 3

How many possible outcomes are there with a single IF statement?

Answer:

2.

Two.

You have two possible outcomes with a single IF statement. For example, something can be Within budget, or Over budget.

The IF function: What it is, and how to use it

Test question 4

If you copy a formula down a column, and need a cell reference to stay the same (for example, you don’t want B2 to change to B3), what type of cell reference do you need? (Pick one answer.)

1.

2.

Relative.

Absolute. The IF function: What it is, and how to use it

Test question 4

If you copy a formula down a column, and need a cell reference to stay the same (for example, you don’t want B2 to change to B3), what type of cell reference do you need?

Answer:

2.

Absolute.

Cell references are relative by default. If you want the cell reference to stay the same, you must convert it to an absolute, which you can do by pressing F4 on your keyboard.

The IF function: What it is, and how to use it

Quick Reference Card

For a summary of the tasks covered in this course, view the Quick Reference Card .

The IF function: What it is, and how to use it