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.
ISNUMBER(value)Returns TRUE if the value is a numeric value; otherwise, returns FALSE.
IF(ISNUMBER(2026 Actuals), 2026 Actuals*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'.
