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 considers the logical values TRUE and FALSE as numbers.

Example:

ISNUMBER(123)
returns TRUE.
ISNUMBER(“dog”)
returns FALSE.
ISNUMBER(D5)
where D5 contains 99, returns TRUE, because D5 contains a number.






 
Created with Zapof