Difference between revisions of "Manuals/calci/ISERROR"

From ZCubes Wiki
Jump to navigation Jump to search
Line 1: Line 1:
=ISERROR (Value)=
+
<div style="font-size:30px">'''ISERROR (Value)'''</div><br/>
  
 
where
 
where
 
*<math>Value</math> is any value.
 
*<math>Value</math> is any value.
 +
**ISERROR(),returns TRUE if the value is any error value.
  
  

Revision as of 15:42, 2 July 2018

ISERROR (Value)


where

  • is any value.
    • ISERROR(),returns TRUE if the value is any error 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.

ISERROR(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