ISNUMBER

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(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'.

Excel equivalent

ISNUMBER