12 April 2014: The OpenOffice Wiki is not, and never was, affected by the heartbleed bug. Users' passwords are safe and wiki users do not need take any actions.

Documentation/How Tos/Calc: ISNUMBER function

From Apache OpenOffice Wiki
Jump to: navigation, search



ISNUMBER

Tests if a cell contains a number.

Syntax:

ISNUMBER(value)

Returns TRUE if value is a number or logical value and FALSE otherwise.


ISNUMBER currently (OOo2.3) considers the logical values TRUE and FALSE as numbers. See Issues below.

Example:

ISNUMBER(123)

returns TRUE.

ISNUMBER(“dog”)

returns FALSE.

ISNUMBER(D5)

where D5 contains 99, returns TRUE, because D5 contains a number.

Issues:

  • ISNUMBER(A1) where A1 is a logical value, returns TRUE. This behaviour is not compatible with other competing spreadsheets. See issue 84266.

See Also

Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_ISNUMBER_function&oldid=225658"
Views
Personal tools
Navigation
Print/export
Tools