Excel 2016 Tips and Tricks

Excel 2016

Lesson – Using Advanced Functions

Using the ISERROR function

NOTE If you are unsure of the contents of one or more cells on which the calculations are being made, you can use the ISERROR function because it provides a result regardless of the error condition.



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



S TEP - BY -S TEP Use the ISERROR function in an IF function.

Display the Quota worksheet.

OFFICEPRO, Inc.

Page 83