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.