Formula to convert resulting #N/A to 0

cehipso · Jul 6, 2006

Formulas using vlookup or similar returns #N/A if values are not found.
How can this string be converted to 0 other way than manually?

Jerry W. Lewis · Jul 6, 2006

=IF(ISNA(formula),0,formula)

Jerry

cehipso · Jul 7, 2006

Jerry W. Lewis said:
=IF(ISNA(formula),0,formula)

Jerry

:
Thanks a lot to Jerry