Ignoring error values in a formula

N

Nicola

Hi, please help I need to add 2 cells together but in some cases there is an
error (#N/A) value in one of cells. How can I ignore the #N/A but still
return the value of the other cell? Everything I've tried returns the value
#N/A. Please help!!
 
A

Anthony D

Hi, There is a function to check if a result is #N/A (value not available) so
for example cell a1 can be checked from another cell by:

=if(isna(a1),0,a1)

the zero being returned if a1 is a #N/A

Anthony
 
Top