Help with #N/A

A

Al G

If I am adding a column that has an #N/A, it returns an #N/A. How can I get
it to work?

I used an if statement where: =if(+B5="#N/A",0,+B5)- it did not work.

Help.

Thanks.
 
J

Jon Peltier

First of all, remove the leading '+' signs.

Second, to test for #N/A, use ISNA():

=IF(ISNA(B5),0,B5)

- Jon
 
Top