/
ERRORCONTAINS
ERRORCONTAINS
Syntax
ERRORCONTAINS(possibleError:<Any>;string:<string>)
Description
- returns FALSE if 'possibleError' is not an ERROR value
- returns TRUE if the ERROR message of 'possibleError' contains the 'string', returns FALSE otherwise
- a NULL 'stringValue' results in a FALSE value
Example
ERRORCONTAINS(#B;'failed')
A | B | ERRORCONTAINS |
---|---|---|
0 | <error> | true |
1 | 5.0 | false |
2 | 2.5 | false |
3 | 1.6666 | false |
4 | 1.25 | false |
, multiple selections available,
Related content
ERRORCONTAINS
ERRORCONTAINS
More like this
ISERROR
ISERROR
More like this
ISERROR
ISERROR
More like this
ERRORMATCHES
ERRORMATCHES
More like this
ERRORMATCHES
ERRORMATCHES
More like this
IFERROR
IFERROR
More like this