Excel 2016 Tips and Tricks

Excel 2016

Lesson 3 – Using Advanced Functions

Steps

Practice Data

9. Press [Enter] .

Press [Enter]

The result of the IF function appears in the cell.

The correct answer is No , since only one condition is true.

Copy the formula to the range D9:D13. Then, click anywhere in the worksheet to deselect the range.

U SING AN OR C ONDITION WITH IF  D ISCUSSION

You can use OR conditions to test multiple criteria in IF functions. For example, you may want to give a salesperson a $500 bonus if she produces $10,000 in sales or if she has at least five years experience. This example represents an OR condition. When used in an IF function, the OR condition returns a TRUE value if either argument is true and a FALSE value if both arguments are false.

The syntax of an OR condition is:

=IF(OR(logical test1,logical test2),value if true,value if false)

OFFICEPRO, Inc.

Page 87