Difference between revisions of "Manuals/calci/ISERROR"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | + | =ISERROR (Value)= | |
| + | |||
| + | where | ||
*<math>Value</math> is any value. | *<math>Value</math> is any value. | ||
| + | |||
==Description== | ==Description== | ||
| Line 6: | Line 9: | ||
*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. | ||
Revision as of 16:19, 4 January 2018
ISERROR (Value)
where
- is any 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.
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
See Also
References