What does this function do?
Returns a specified value if a formula evaluates to an error; otherwise it returns the result of the formula.
Syntax:
IFERROR(value,value_if_error)
Value (required): is the argument that is checked for an error.
Value_if_error (optional): is the value to return if the formula evaluates to an error. The following error types are evaluated: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!.
Examples:
If A1 = 0
=IFERROR (A1/1, "problem") = 0
=IFERROR = (1/A1, "problem") = problem
No comments:
Post a Comment