Excel 2016 Tips and Tricks

Lesson 3 – Using Advanced Functions

Excel 2016



S TEP - BY -S TEP Use an AND condition in an IF function.

Display the Raises worksheet.

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.

Click cell D8

Type =if(

3. Type the AND condition.

Type and(b8>0,c8>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 both conditions are true. The text appears in the cell and on the formula bar.

Type " Yes "

6. Type a comma ( , ).

Type ,

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

7. Type the action to be taken if either condition is false.

Type " No "

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

8. Type a closing parenthesis ( ) ). The closing parenthesis ( ) ) appears in the cell and on the formula bar.

Type )

Page 86

OFFICEPRO, Inc.