I would like to hide the following formula...
 

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

I would like to hide the following formula...
 

"VB" skrev i en meddelelse
...
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.

I would like to hide the following formula...
 

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

I would like to hide the following formula...
 

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


"Leo Heuser" wrote:

"VB" skrev i en meddelelse
...
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.

I would like to hide the following formula...
 

Dear VB

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

HTH
OverAC


--
OverAC
------------------------------------------------------------------------
OverAC's Profile: http://www.excelforum.com/member.php...o&userid=32396
View this thread: http://www.excelforum.com/showthread...hreadid=565024

I would like to hide the following formula...
 

Thanks for the feedback Vicki.

Ken Johnson

I would like to hide the following formula...
 

"VB" skrev i en meddelelse
...
Leo & Ken... You Rock! :-)
--
Vicki B


Thanks for the feedback, Vicki :-)

Leo Heuser