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
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