Replacing #N/A with a '0' (zero)

[neilcarden]

Thanks again you guys!!! Excellent...

 

[galimi]

=if(isna(cell_ref),0,cell_ref)

Replace cell_ref with the one cell range being referenced

http://HelpExcel.com