IFERROR Function in Excel

1 Comment / Excel Function, Excel Tutorial, Logical Function

IFERROR Function in Excel: We will learn about syntax and how to use iferror function in Excel with examples.

Description:

The Function returns a custom value when a function generates an error, otherwise, it returns the result of the value part. The most useful function of Excel to manage errors in a formula in Excel.

Syntax:

=IFERROR(Value, Value_If_Error)

  • Value – The formula, reference or value that may generate an error.
  • Value_If_Error – The value to return, if an error is detected.

Example:

If we try to divide a number by zero, excel will display #DIV/0 error.

Above example show you how to use iferror function at the time division. When you divide a number with zero it returns an error of #DIV/0, to solve this problem we will use iferror function.

1 thought on “IFERROR Function in Excel”

Comments are closed.