Use the IFERROR function in Excel to return an alternative result, such as text, when a formula evaluates to an error.
This example illustrates the ISERROR function in Excel.
Excel stores and calculates floating point numbers. Sometimes, the result of a formula is a very close approximation.
Formula auditing in Excel allows you to display the relationship between formulas and cells.
Excel functions such as SUM, COUNT, LARGE and MAX don’t work if a range includes errors.
A formula in a cell that directly or indirectly refers to its own cell is called a circular reference.