Checks whether a cell value is a valid number and returns TRUE or FALSE.
The ISNUMBER function returns TRUE if the specified value is a valid number. It returns FALSE if the value is not numeric. It is commonly used with IF and other conditional functions to validate numeric inputs before performing calculations.
Syntax
ISNUMBER(value)
Arguments
value - The value to evaluate.
Return value
Returns TRUE if the value is a numeric value; otherwise, returns FALSE.
Example
IF(ISNUMBER(2026Actuals),2026Actuals*1.05,"Not a number")
In this example, the ISNUMBER function checks whether 2026 Actuals contains a numeric value. If the condition is TRUE, the formula applies a 5% increase to the value; otherwise, it returns 'Not a number'.
