Invoice Template Help #2

[Heather]

I didn't ask my previous question correctly. Here is the prevouis question:


We have an invoice template set up in Excel. We want to continue showing the
total for each individual item in the total column, but at the bottom where
we have total material, sales tax, and the total balace due broke out, we
want to keep some of those boxes blank. What we want is a the total material
and sales tax boxes to stay blank, but a total of the two boxes to appear in
the total due box. - This has been solved. I don't need this anymore.

What I am needing is the material total and sales tax boxes to show the
number on screen but when printing, show blank boxes. Can this be done and
if so how?

Thank You again!
Heather

 

[dq]

Hallo Heather,

If these cells are on the edge of the screen you could define a print
area that excludes these so they won't be printed.
Another option is to define a name somewhere that you set to true when
you're going to print and to false afterwards. (perhaps by using a
checkbox or toggle button and then you make your formula like this
=IF(Printing=TRUE,"",A1*1.21)

DQ