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