I would like to hide the following formula...

V

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,
 
L

Leo Heuser

VB said:
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,
Click to expand...

Hi Vicki

One way:

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

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
 
V

VB

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


Leo Heuser said:
Hi Vicki

One way:

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

--
Best regards
Leo Heuser

Followup to newsgroup only please.
Click to expand...
 
O

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
 
Top