replace #N/A value in EXCEL by 0 ????

  • Thread starter Thread starter DAVID
  • Start date Start date
D

DAVID

I'm using very large EXCEL Sheet for import of external data. After I make
new calculations, which will be shown in the master-TAB.
I receive many "#N/A" values of course, but I don't care about. I just like
to make total calculation of the colums. But result of calculation for
certain range (column) which contains the "#N/A" values, gives me back a
"#N/A" value.
Is there a way to REPLACE the "#N/A" values by a "0" ????
Just like "REPLACE" ....

Thanks for your help, which would be appreciated
 
=IF(ISNA(x),0,x)

As long as you are only totalling results, this should work fine. If you
want averages, etc, then you should probably use "" instead of 0.

Jerry
 
Back
Top