K
Kevin
A B C D E
DATE GST AMOUNT TOT - GST TO DATE
$10.00 $10.00 $10.00
$10.00 $10.00 $20.00
$10.00 $10.00 $30.00
$10.00 $10.00 $40.00
$0.00 $40.00
$0.00 $40.00
$0.00 $40.00
$0.00 $40.00
$0.00 $40.00
$0.00 $40.00
Column D is C-B
Column E is the total of D to date
How can I get rid of the zero's in D? If I do not enter an amount in C on a
given day I would like D to be blank. The way I have done it in the past is
with a conditional format If D=0 then Format the cell white. I know there
must be a better way.
Next question is if I have not entered an amount for a given day in C then I
would also like E to be blank.
It is an expense for so every line will be used, there will be no dates
without an entry. I just dont want the zero's and the TOT to carry on every
line to the bottom.
Thanks
Kevin
DATE GST AMOUNT TOT - GST TO DATE
$10.00 $10.00 $10.00
$10.00 $10.00 $20.00
$10.00 $10.00 $30.00
$10.00 $10.00 $40.00
$0.00 $40.00
$0.00 $40.00
$0.00 $40.00
$0.00 $40.00
$0.00 $40.00
$0.00 $40.00
Column D is C-B
Column E is the total of D to date
How can I get rid of the zero's in D? If I do not enter an amount in C on a
given day I would like D to be blank. The way I have done it in the past is
with a conditional format If D=0 then Format the cell white. I know there
must be a better way.
Next question is if I have not entered an amount for a given day in C then I
would also like E to be blank.
It is an expense for so every line will be used, there will be no dates
without an entry. I just dont want the zero's and the TOT to carry on every
line to the bottom.
Thanks
Kevin