Another Quick Question

[Heather]

How do I keep my cells from showing "#Value" (in a blank cell w/ a formaula)
when I print a worksheet?

Thanks!

[daddylonglegs]

It depends which sort of formula you're using, can you post it?

[Heather]

I have it set up so that when I type a certain number (ie 101) in cell A1 it
will post a number or description in C1. This a quote sheet for customers,
so I want to be able to see certain numbers, but then when I print, I would
like certain cells blank.

"daddylonglegs" wrote:

>
> It depends which sort of formula you're using, can you post it?
>
>
> --
> daddylonglegs
> ------------------------------------------------------------------------
> daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
> View this thread: http://www.excelforum.com/showthread...hreadid=538168
>
>

[Tom Ogilvy]

=if(iserror(formula),"",formula)

or if you want to see the error except for printing, use a dummy cell.
Let's say it is cell Z1

=if(Z1="",formula,if(iserror(formula),"",formula))

then when you want to print, put a value in Z1.

You can also use conditional formatting and check for an error value. then
if it is an error, change the font color to match the background. However,
some printers will recognize this lack of contrast and adjust the color so
you can see the value.

--
Regards,
Tom Ogilvy


"Heather" wrote:

> I have it set up so that when I type a certain number (ie 101) in cell A1 it
> will post a number or description in C1. This a quote sheet for customers,
> so I want to be able to see certain numbers, but then when I print, I would
> like certain cells blank.
>
> "daddylonglegs" wrote:
>
> >
> > It depends which sort of formula you're using, can you post it?
> >
> >
> > --
> > daddylonglegs
> > ------------------------------------------------------------------------
> > daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
> > View this thread: http://www.excelforum.com/showthread...hreadid=538168
> >
> >