OpenOffice3.org Calc 3. Information Functions

ISERROR(value) Function

Returns a logical value. The funtion returns TRUE if the argument contains any error value. By contrast, the function returns FALSE if the argument constains a data that is not an error. The argument “value” contains the reference to a cell or an expression . If after evaluating the contents of the cell or expression, the argument is an error value, the function returns TRUE. For example:

=ISERROR(300/0) The function returns TRUE. The argument is the rror value #DIV/0!, is trying to divide a number by zero.

=ISERROR(SUM("eee";3;5)) Returns TRUE. The argument is the error value #VALUE!. Note that the SUM function has one argument that is not a number.

Back to the list of information functions