Help with #N/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.

 

[Mike H]

Try,

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

Mike

 

[Jon Peltier]

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

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

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

- Jon

 

[Niek Otten]

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