Manuals/calci/ISERROR

Revision as of 13:52, 7 November 2017 by Devika (talk | contribs) (→‎Examples)
ISERROR (Value)


  • is any value.

Description

  • This function is one of the group in ISFUNCTIONS.
  • The IS FUNCTION is also known as data information functions, data inspection functions or data-testing functions.
  • This function is the tester function of error values.
  • In ISERROR(Value),Value is any number or non numeric.
  • This function will return the result as TRUE when the given value any error value.
  • And will return the result as FALSE when the given Value is any numeric or non numeric value.

Examples

  1. ISERROR("Saturday") = false
  2. ISERROR(-451) = false
  3. ISERROR(#) = true

See Also


References