Excel 2016 Tips and Tricks

Excel 2016

Lesson 3 – Using Advanced Functions

Steps

Practice Data

2. Type =if and an open parenthesis ( ( ). =if( appears in the cell and on the formula bar, and a Screen Tip appears.

Type =if(

3. Type the OR condition.

Type or(b8>10000,c8=3)

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 either of the conditions is 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 both conditions are 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 " No "

Type )

9. Press [Enter] .

Press [Enter]

The result of the IF function with the OR condition appears in the cell.

The correct answer is No , since neither condition is true.

Copy the formula to the range E9:E13. Then, click anywhere in the worksheet to deselect the range.

OFFICEPRO, Inc.

Page 89