Last updated 2 years ago
Was this helpful?
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