Excel 2016 Tips and Tricks

Lesson 3 – Using Advanced Functions

Excel 2016

NOTE You must close all parentheses in a nested IF function; for example, the number of opening parentheses must equal the number of closing parentheses.



P ROCEDURES

1. Select the cell in which you want the result of the nested IF function to appear. 2. Type =if and an open parenthesis ( ( ). 3. Type the first logical test. 4. Type a comma ( , ). 5. Type the action to be taken if the first logical test is true. 6. Type a comma ( , ). 7. Type if and an open parenthesis ( ( ). 8. Type the logical test for the second IF function. 9. Type a comma ( , ). 10. Type the action to be taken if the logical test for the second IF function is true. 11. Type a comma ( , ). 12. Type the action to be taken if the second logical test is false. 13. Type two closing parentheses ( )) ). 14. Press [Enter] .



S TEP - BY -S TEP

Use nested IF functions.

If necessary, display the Bonus worksheet.

Steps

Practice Data

1. Select the cell in which you want the result of the nested IF

Click cell J8

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.

Type =if(

Page 80

OFFICEPRO, Inc.