error(
MESSAGE
)

The error( function returns an error with the specified message.


Parameters

This function has one parameter:

message – The error message to return.


Description

This function generates an error. It is usually used with the ?( or switch( functions, like this:

?(Price>0,Price,error("Negative or zero price is not allowed"))

Note that this function is not generating a text value, it is generating an error. This means, for example, that in this case a negative price would stop a procedure that contained this formula (unless the procedure used error trapping).


See Also


History

VersionStatusNotes
10.0NewNew in this version