Excel 2016 Tips and Tricks

Lesson 3 – Using Advanced Functions

Excel 2016

Steps

Practice Data

1. Select the cell in which you want the result of the IF function to appear. The cell is selected. 2. Type =if and an open parenthesis ( ( ). =if( appears in the cell and on the formula bar. As you start typing a function, a Screen Tip is displayed to help you enter valid arguments.

Click cell G8

Type =if(

3. Type the logical test.

Type e8>f8

The text appears in the cell and on the formula bar.

4. Type a comma ( , ).

Type ,

The comma ( , ) appears in the cell and on the formula bar.

5. Type the action to be taken if the logical test is true. The text appears in the cell and on the formula bar.

Type e8*10%

6. Type a comma ( , ).

Type ,

The comma ( , ) appears in the cell and on the formula bar.

7. Type the action to be taken if the logical test is false. The text appears in the cell and on the formula bar. 8. Type the closing parenthesis ( ) ) . The closing parenthesis ( ) ) appears in the cell and on the formula bar.

Type 0

Type )

9. Press [Enter] .

Press [Enter]

The result of the IF function appears in the cell.

Notice that since the first quarter sales total for Smith, S. was below his quota, a zero ( 0 ) was entered as his bonus.

Page 78

OFFICEPRO, Inc.