Excel 2016 Tips and Tricks

Lesson – Using Advanced Functions

Excel 2016

Creating an OR condition in an IF function



P ROCEDURES

1. Select the cell in which you want the result of the IF function to appear. 2. Type =if and an open parenthesis ( ( ). 3. Type the OR condition. 4. Type a comma ( , ). 5. Type the action to be taken if either of the conditions is true. 6. Type a comma ( , ). 7. Type the action to be taken if both conditions are false. 8. Type the closing parenthesis ( ) ). 9. Press [Enter] .



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

If necessary, 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.

Click cell E8

Page 88

OFFICEPRO, Inc.