I would like to hide the following formula...

[VB]

I have created a formula which when copied 'down' displays the #Div/0! error
message. This is fine, becasue excel will perform the calculation correctly
when I get to that row but I want to blank that cell when printing so that I
don't get this error message all over my print-out.

Does anyone know a way to blank that cell (without losing the formula) in a
similar way to the concept behind the 'hide zeros' feature?

Thanks,
--
Vicki B

[Leo Heuser]

"VB" <[email protected]> skrev i en meddelelse
news:[email protected]...
>I have created a formula which when copied 'down' displays the #Div/0!
>error
> message. This is fine, becasue excel will perform the calculation
> correctly
> when I get to that row but I want to blank that cell when printing so that
> I
> don't get this error message all over my print-out.
>
> Does anyone know a way to blank that cell (without losing the formula) in
> a
> similar way to the concept behind the 'hide zeros' feature?
>
> Thanks,
> --
> Vicki B

Hi Vicki

One way:

=IF(ISERROR(YourFormula),"",YourFormula)

--
Best regards
Leo Heuser

Followup to newsgroup only please.

[Ken Johnson]

Hi Vicki B,

One way is ...

IF(ISERROR(Your Formula),"",Your Formula)

If the error is due to a particular cell value being zero, say A1,
then...

IF(A1=0,"",Your Formula)

Ken Johnson

[VB]

Leo & Ken... You Rock! :-)
--
Vicki B


"Leo Heuser" wrote:

> "VB" <[email protected]> skrev i en meddelelse
> news:[email protected]...
> >I have created a formula which when copied 'down' displays the #Div/0!
> >error
> > message. This is fine, becasue excel will perform the calculation
> > correctly
> > when I get to that row but I want to blank that cell when printing so that
> > I
> > don't get this error message all over my print-out.
> >
> > Does anyone know a way to blank that cell (without losing the formula) in
> > a
> > similar way to the concept behind the 'hide zeros' feature?
> >
> > Thanks,
> > --
> > Vicki B
>
> Hi Vicki
>
> One way:
>
> =IF(ISERROR(YourFormula),"",YourFormula)
>
> --
> Best regards
> Leo Heuser
>
> Followup to newsgroup only please.
>
>
>

[OverAC]

Dear VB

Access Dialog box "Page Setup" (menu File --> Page Setup) -->
Choose "Sheet" In the Print Frame, choose Cell error as Blank

HTH
OverAC

[Ken Johnson]

Thanks for the feedback Vicki.

Ken Johnson

[Leo Heuser]

"VB" <[email protected]> skrev i en meddelelse
news:[email protected]...
> Leo & Ken... You Rock! :-)
> --
> Vicki B
>

Thanks for the feedback, Vicki :-)

Leo Heuser

[Leo Heuser]

"VB" <[email protected]> skrev i en meddelelse
news:[email protected]...
> Leo & Ken... You Rock! :-)
> --
> Vicki B
>

Thanks for the feedback, Vicki :-)

Leo Heuser