Documentation/Calc Functions/ISNUMBER

Function name:
ISNUMBER

Category:
Information

Summary:
Determines whether the supplied argument results in a number.

Syntax:
ISNUMBER(Value)

Returns:
Returns TRUE if the argument evaluates to a number and FALSE otherwise.

Arguments:
Value is an expression, or a reference to a cell containing an expression, that is to be tested to determine if it evaluates to a number.


 * If Value evaluates to a logical value (TRUE or FALSE) or a date-time, then ISNUMBER returns TRUE.

Additional details:

 * ISNUMBER does not propagate errors. If Value evaluates to a number, then ISNUMBER returns TRUE and returns FALSE otherwise.
 * For arguments that evaluate to logical values, Calc's ISNUMBER function differs from the corresponding Microsoft Excel function (presumably because the two applications handle logical values in different ways). While Calc returns the value TRUE for the formula, Excel returns FALSE for the same formula.

Related LibreOffice functions:
ISLOGICAL

ISTEXT

ODF standard:
Section 6.13.22, part 2

Equivalent Excel functions:
ISNUMBER