Summary
The Excel ISNUMBER function returns TRUE when a cell contains a number, and FALSE if not.
Purpose
Test for numeric value
Return value
A logical value (TRUE or FALSE)
Syntax
=ISNUMBER (value)
Arguments
- value – The value to check.
Usage notes
Use the ISNUMBER function to check if a value is a number. ISNA will return TRUE when value is numeric and FALSE when not.
For example, =ISNUMBER(A1) will return TRUE if A1 contains a number or a formula that returns a numeric value. If A1 contains text, ISNUMBER will return FALSE.
Normally, value is supplied as a cell address.
ISNUMBER is part of a group of functions called the IS functions.