Excel 2016 Tips and Tricks

Excel 2016

Lesson 3 – Using Advanced Functions

Steps

Practice Data

3. Type the first logical test.

Type i8=1

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

Type h8*10%

6. Type a comma ( , ).

Type ,

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

7. Type if and an open parenthesis ( ( ). if( appears in the cell and on the formula bar.

Type if(

8. Type the logical test for the second IF function.

Type i8=2

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

9. Type a comma ( , ).

Type ,

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

10. Type the action to be taken if the logical test for the second IF function is true. The text appears in the cell and on the formula bar.

Type h8*8%

11. Type a comma ( , ).

Type ,

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

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

Type h8*7%

OFFICEPRO, Inc.

Page 81