software

Hi

I have a sheet that works out some stuff for me. it runs from Jan 2000
til Dec 2006.

everything works out except for the cells in the future, like, Today
through to Dec 2006 where the cell has #REF showing. I have a
formula that is date related and so it throws up an error. how can I
hide that content?

regardsSomething like:

=if(iserror(formula),quot;quot;,formula)

HTH

quot;bobtraceyquot; wrote:

gt; Hi
gt;
gt; I have a sheet that works out some stuff for me. it runs from Jan 2000
gt; til Dec 2006.
gt;
gt; everything works out except for the cells in the future, like, Today
gt; through to Dec 2006 where the cell has #REF showing. I have a
gt; formula that is date related and so it throws up an error. how can I
gt; hide that content?
gt;
gt; regards
gt;
gt;