return 0 for error value #N/A in microsoft excel?

[Guest]

how to return result value 0 in a different cell for error value #N/A in
microsoft excel?while the result value for other cells containing numbers
return same numbers? all must be done in single command or function.

 

[Jack Schitt]

=IF(ISNA(expression),0,expression)

 

[JE McGimpsey]

One way:

=IF(ISNA(A1),0,A1)