Excel 2016 Tips and Tricks

Excel 2016

Lesson – Using Advanced Functions

Copy the formula to the range G9:G13. Then, click anywhere in the worksheet to deselect the range.

U SING N ESTED IF F UNCTIONS  D ISCUSSION

You can use an IF function within another IF function to create a nested IF function. A nested IF function allows you to test for a second condition if the first condition is found false. For example, an IF function could test whether a number is equal to 1 . If false, another IF function within the first could test whether the number is equal to 2 .

The syntax of a nested IF function is:

=IF(logical test,value if true,IF(logical test,value if true,value if false))

You can create formulas with up to 64 levels of nested functions.

Creating a nested IF function

OFFICEPRO, Inc.

Page 79