If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Don't show Zeros
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. |
#2
|
|||
|
|||
Don't show Zeros
From the menu, Tools, Options, View, Zero Values. This
will remove them. -----Original Message----- 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. . |
#3
|
|||
|
|||
Don't show Zeros
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 |
Thread Tools | |
Display Modes | |
|
|