Difference between revisions of "Manuals/calci/ISERROR"

From ZCubes Wiki
Jump to navigation Jump to search
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
<div style="font-size:30px">'''ISERROR (Value)'''</div><br/>
 
<div style="font-size:30px">'''ISERROR (Value)'''</div><br/>
 +
 +
where
 
*<math>Value</math> is any value.
 
*<math>Value</math> is any value.
 +
**ISERROR(),returns TRUE if the value is any error value.
 +
  
 
==Description==
 
==Description==
Line 6: Line 10:
 
*The IS FUNCTION is also known as data information functions, data inspection functions or data-testing functions.
 
*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.
 
*This function is the tester function of error values.
*In ISERROR(Value),Value is any number or non numeric.
+
ISERROR(Value),
 +
*<math>Value</math> is any number or non numeric.
 
*This function will return the result as TRUE when the given value any error value.
 
*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.
 
*And will return the result as FALSE when the given Value is any numeric or non numeric value.
Line 14: Line 19:
 
# ISERROR(-451) = false
 
# ISERROR(-451) = false
 
# ISERROR(#) = true
 
# ISERROR(#) = true
 +
 +
==Related Videos==
 +
 +
{{#ev:youtube|v=YC0MetXqSKI|280|center|Is Error}}
  
 
==See Also==
 
==See Also==

Latest revision as of 14:13, 7 March 2019

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

Related Videos

Is Error

See Also


References