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 whe =if(+B5="#N/A",0,+B5)- it did not work.

Help.

Thanks.

Try,

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

Mike

"Al G" wrote:

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 whe =if(+B5="#N/A",0,+B5)- it did not work.

Help.

Thanks.

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

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

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Al G" <Al wrote in message
...
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 whe =if(+B5="#N/A",0,+B5)- it did not work.

Help.

Thanks.

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Al G" <Al wrote in message
...
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 whe =if(+B5="#N/A",0,+B5)- it did not work.

Help.

Thanks.