ISNUMBER

The ISNUMBER function returns the logical value TRUE if the value argument is a valid number; otherwise, it returns FALSE.

Syntax

isnumber(value)

Arguments

value - cell or reference or expression

Return value

Either True or False

Example

if(isnumber((AC-PY)/PY), (AC-PY)/PY, 0)

Returns AC-PY/PY if the value is a number else returns 0

Excel equivalent

ISNUMBER