Formula to convert resulting #N/A to 0

[cehipso]

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]

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

Jerry

"cehipso" wrote:

> 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?

[cehipso]

"Jerry W. Lewis" wrote:

> =IF(ISNA(formula),0,formula)
>
> Jerry
>
> "cehipso" wrote:
>Thanks a lot to Jerry
> > 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?