ISNUMBER

The ISNUMBER function checks if the value is a number.

Returns TRUE if it is and FALSE if not.

This function can be useful for validating data and processing various types of input values.

Syntax

ISNUMBER(value)

Argument	Description	Permitted values
value	Value that is checked for whether it is a number or not	Any value (number, text, formula, cell reference, and so forth)

Examples of use

Checking the value in a cell

=ISNUMBER(A1)

If cell A1 contains a number, the function returns TRUE.

If A1 contains text or is empty, FALSE will be returned.

Use in a conditional formula

=IF(ISNUMBER(B1), "This is a number", "This is not a number")

If the value in cell B1 is a number, the function returns “This is a number”; otherwise, it returns “This is not a number.”

Notes

Please note that the function recognizes number formats such as dates and monetary amounts as numbers.