Showing posts with label excel. Show all posts
Showing posts with label excel. Show all posts

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)