Difference between revisions of "Manuals/calci/ISERROR"
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. | ||
− | + | 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
- ISERROR("Saturday") = false
- ISERROR(-451) = false
- ISERROR(#) = true
Related Videos
See Also
References