Re: how to remove #N/A
- From: "Jon Peltier" <jonxlmvpNO@xxxxxxxxxxxxxxxxxxx>
- Date: Tue, 20 Mar 2007 16:59:53 -0400
=IF(ISNA(blah),"",blah)
=IF(ISNA(blah),0,blah)
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"Charlie_Brown" <Charlie_Brown@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DE045C07-3437-4B15-8A58-38D275C87DFE@xxxxxxxxxxxxxxxx
I have a large spreadh*** (21k rows) that creates alot of #N/A as
designed.
I would like to change the #N/A to zero removing the formula. This is not
a
one time deal as I need to re-create the spread*** weekly. I do not
want
to value out the entire spread***.
.
- Prev by Date: Re: Return Author Comment
- Next by Date: Re: Import from finance.yahoo.com
- Previous by thread: Re: Plot series on top of other series
- Next by thread: Re: how to remove #N/A
- Index(es):
