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?
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.