Excel 2016 Tips and Tricks

Excel 2016

Lesson – Using Advanced Functions

IF Function

Result

If cell B7 contains the text BONUS , add 1000 to the number in cell C7; otherwise, enter the contents of cell C7

=IF(B7="BONUS",C7+1000,C7)

Creating 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 logical test. 4. Type a comma ( , ). 5. Type the action to be taken if the logical test is true. 6. Type a comma ( , ). 7. Type the action to be taken if the logical test is false. 8. Type the closing parentheses ( ) ). 9. Press [Enter] .



S TEP - BY -S TEP

Use the IF function.

Display the Bonus worksheet.

OFFICEPRO, Inc.

Page 77