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

IF(EQUALS(#A;0);ERROR('division by zero');#A