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

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.

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

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

--
Return email address is not as DEEP as it appears
"jw_78" wrote in message
...
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.

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

One way:

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

In article ,
"jw_78" wrote:

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.