ISNUMBER
Syntax
isnumber(value)Arguments
Return value
Example
if(isnumber((AC-PY)/PY), (AC-PY)/PY, 0)Excel equivalent
Last updated
Was this helpful?
⌘Ctrlk
The ISNUMBER function returns the logical value TRUE if the value argument is a valid number; otherwise, it returns FALSE.
isnumber(value)value - cell or reference or expression
Either True or False
if(isnumber((AC-PY)/PY), (AC-PY)/PY, 0)Returns AC-PY/PY if the value is a number else returns 0
Last updated
Was this helpful?
Was this helpful?