• Create BookmarkCreate Bookmark
• Create Note or TagCreate Note or Tag
• PrintPrint

Performing a Logical Test Function (IF)

Click in the cell in which you want the result of the function to appear (this is called the resultant cell).

Click the down arrow next to the AutoSum button on the Standard toolbar and choose More Functions from the list that appears.

The Insert Function dialog box opens. Click the down arrow next to the Or select a category field and choose Logical from the list that appears.

A list of logical functions appears in the Select a function list. Scroll through the list to locate the IF function, and double-click it.

INTRODUCTION

Using Excel, you can perform a logical test function—for example, to indicate whether scores equal a passing or failing grade based on an established set of criteria.

TIP

Embedded IFs

You can set up embedded IF statements to use in your logical test. For example, suppose scores between 90–100 are an A, 80–89 are a B, 70–79 are a C, 60–69 are a D, and below 59 are an F. Your formula might look like this: =IF(B3>89, “A”, IF(B3>79, “B”, IF(B3>69, “C”, IF(B3>59, “D”, “F”).

In the Logical_test field, type the condition to determine whether a grade is above 70. The logical test is if the cell is greater than 70, for example, B3>70.

In the Value_if_true field, type the value you want to use if the grade is above 70 (that is, a passing grade)—for example, “Pass”.

In the Value_if_false field, type the value you want to use if the grade is below 70 (that is, a failing grade)—for example, “Fail”. Click OK.

Excel performs the logical test and inserts the result in the resultant cell.

PREVIEW

Not a subscriber?

Start A Free Trial

• Create BookmarkCreate Bookmark
• Create Note or TagCreate Note or Tag
• PrintPrint