Before you begin If a yellow security bar appears at the top of the screen in PowerPoint, click Enable Editing. You need PowerPoint.
Download ReportTranscript Before you begin If a yellow security bar appears at the top of the screen in PowerPoint, click Enable Editing. You need PowerPoint.
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