Using IFERROR Function In Excel On MS Office.

Asked By 0 points N/A Posted on -
qa-featured

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?

SHARE
Answered By 0 points N/A #298952

Using IFERROR Function In Excel On MS Office.

qa-featured

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.

Login/Register to Answer

Related Questions