OpenOffice3.org Calc 3. Information Functions

ISNUMBER(value) Function

Returns a logical value. The function returns TRUE if the argument “value” constains a numeric value. If the argument “value” contains a number, the function returns FALSE. The argument “value” contains the reference to a cell, a constant or an expression. The function returns TRUE if the argument contains a number, date, time, or a logical value. For example:

=ISNUMBER(45) Returns TRUE. Indicates that the argument is a number.
=ISNUMBER("rosa") Returns FALSE. The argument is not a number.
=ISNUMBER(8+8) Returns TRUE. The argument contains a number.

 

Back to the list of information functions