Using IFERROR Function In Excel On MS Office.

Asked By Vincent L Sanchez 0 points N/A Posted on - 06/09/2017

I am using Microsoft Excel 2016 and having trouble with IF function. The function has vast scope and I know a little about it. How can I use IFERROR function in Excel on MS Office?

• Status: Open
• Question Views: 418
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Microsoft Office
• Question Tags: Excel | MS Office

Answered By caitlynbrooklynn 0 points N/A #298952

Using IFERROR Function In Excel On MS Office.

The IFERROR function returns a value specified if the provided formula calculates an error or, returns the result. They can be used to handle and trap errors in formula. It can be useful to check the error in the formula for various cases. For e.g. “=IFERROR(A2/B2, “Error in calculation”)” check the error in the formula and if there is no error, returns the result. It returns the value as Error In Calculation, whenever there is an error.

About caitlynbrooklynn

Questions
11

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 06/09/2017
• Question Category: Microsoft Office