Don't show Zeros

[Morpheseus]

I know I've seen this somewhere but I cannot find it. I looked all day with
no luck. I have to ask what I know is a simple question

I did up an invoice. All works well but I want to decorate it by having the
zeros NOT SHOW in rows where ther are no QTY or Price extensions.

IE..

1 Widget $20 $20
1 Ugly widget $30 $30
2 Bags $20 $40
$00.00
$00.00
$00.00


TOTAL $90.00

What is the formula to make those zero totals not show?

Thanks in advance.

Nick.

 

[Barb]

From the menu, Tools, Options, View, Zero Values. This
will remove them.

 

[Andy Brown]

Barb gave you one option.
Another way would be to apply conditional formatting so that the font is
white for cells where total = 0.

Alternatively, you may need a method that allows you to show zero values
elsewhere (eg: tax).
With QTY -- Item -- Price -- Total in A11, try something like
=IF(COUNTA(A2:C2)<3,"",A2*C2)
in D2.

Rgds,
Andy