Don't show Zeros

  • Thread starter Thread starter Morpheseus
  • Start date Start date
M

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 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 A1:D1, try something like
=IF(COUNTA(A2:C2)<3,"",A2*C2)
in D2.

Rgds,
Andy
 
Back
Top