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.