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, and a Screen Tip appears. 3. Type the ISERROR function as the logical test. The text appears in the cell and on the formula bar.

Click cell F15

Type =if(

Type iserror(average(f8:f13))

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 ISERROR function is true. The text appears in the cell and on the formula bar.

Type " no data "

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 ISERROR function 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 average(f8:f13)

Type )

9. Press [Enter] .

Press [Enter]

The result of the ISERROR function appears in the cell.

The formula returns the text no data instead of the error message. Copy the formula to the range G15:I15. Then, type 50,000 in cell F8 and press [Enter] ; notice that the result in cell F15 changes.

Page 84

OFFICEPRO, Inc.