ERROR
Syntax
ERROR(Message:<String>)
Description
- allows to use 'IF' or 'CASE' function to result in an error when a condition does or does not pass
- sets a cell error when the error handling mode is 'Ignore - leaves the cell(s) blank, logs an error' and the whole column won't be in an error
- results in a field error with passed-in string message
- useful for use-cases around around validation and cleansing data
- will also allow for dropping records or aborting a workbook run when the error handling mode is set to one of those respectively
Example
IF(EQUALS(#A;0);ERROR('division by zero');#A
| Column A | Column B with Result |
|---|---|
| 0 | <error> |
| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
| 4 | 4 |
| 5 | 5 |