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
Last updated