Using the Excel ISNUMBER Function


The Excel ISNUMBER function will return TRUE when a cell contains a number, and FALSE for any other values. The function is useful when determining if a cell contains a number or if the output of a formula is a numeric value.



Syntax Breakdown

Required. A value that will be tested to determine if it is a numeric value or not. Typically supplied as a cell address.

Usage Notes

ISNUMBER checks if a value is a number and returns TRUE if it is, and FALSE if it is not.

The ISNUMBER function will return TRUE for dates and times since they are numbers. A number entered as text will return FALSE.