Replace a #N/A with a '0'

[zakynthos]

How would I replace all cells containing '#N/A' with a '0' ?

I've tried =If( ... etc and it just returns another #N/A

 

[kpark91]

Try looking into
IFERROR formula or ISERROR

=IFERROR('your formula', 0)

 

[ZPhantom]

try

If(IsNA(A1),0,"")

changing A1 to whatever cell your using

IsNA is a built in function that simply tests for that one error type and returns TRUE if the type is '#N/A' and False if its anything else.

ZP

 

[DJWH]

You can also use

=IF(ISNA(Formula),0,Formula)

 

[zakynthos]

Thanks for all the suggestions, I used:

=IF(ISNA(Formula),0,Formula)

and it works perfectly.