15 January 2014

Evaluate excel formula errors

IFERROR function return the value that you specify when a formula evaluates to one of the following errors:

  • #N/A
  • #VALUE!
  • #REF!
  • #DIV/0!
  • #NUM!
  • #NAME?
  • #NULL!
IFERROR(Value / formula that is evaluated, Value_if_error)

No comments:

Post a Comment