How to hide running total in successive cells in a column

I have a spreadsheet with a column titled current balance. When I enter
costs into other line items and this column updates with the new balance, the
balance shows up in all of the cells below as well. How do I stop that from
happeneing?

Hi Jennifer,

assuming that your file looks like this:

A B C D
1 date descrip D/C Balance
2 Jan-02 xxxxx 100.00 100.00
3 Jan-15 cost -50.00 50.00
4 50.00
5 50.00

use on D column a formula =if(c4="";"";(d3+c4))

hth
regards from Brazil
Marcelo


"JenniferAnderson" escreveu:

> I have a spreadsheet with a column titled current balance. When I enter
> costs into other line items and this column updates with the new balance, the
> balance shows up in all of the cells below as well. How do I stop that from
> happeneing?

After some playing with it, it works! For some reason unknown to me, excel
did not like the use of ; (semicolon) but when I plugged in a , (comma) then
IT'S MAGIC!
Thanks for taking time to help me out.

"Marcelo" wrote:

> Hi Jennifer,
>
> assuming that your file looks like this:
>
> A B C D
> 1 date descrip D/C Balance
> 2 Jan-02 xxxxx 100.00 100.00
> 3 Jan-15 cost -50.00 50.00
> 4 50.00
> 5 50.00
>
> use on D column a formula =if(c4="";"";(d3+c4))
>
> hth
> regards from Brazil
> Marcelo
>
>
> "JenniferAnderson" escreveu:
>
> > I have a spreadsheet with a column titled current balance. When I enter
> > costs into other line items and this column updates with the new balance, the
> > balance shows up in all of the cells below as well. How do I stop that from
> > happeneing?

thanks for the feedback, sorry for the ; (semicolon) we use it here in Brazil

regards

"JenniferAnderson" escreveu:

> After some playing with it, it works! For some reason unknown to me, excel
> did not like the use of ; (semicolon) but when I plugged in a , (comma) then
> IT'S MAGIC!
> Thanks for taking time to help me out.
>
> "Marcelo" wrote:
>
> > Hi Jennifer,
> >
> > assuming that your file looks like this:
> >
> > A B C D
> > 1 date descrip D/C Balance
> > 2 Jan-02 xxxxx 100.00 100.00
> > 3 Jan-15 cost -50.00 50.00
> > 4 50.00
> > 5 50.00
> >
> > use on D column a formula =if(c4="";"";(d3+c4))
> >
> > hth
> > regards from Brazil
> > Marcelo
> >
> >
> > "JenniferAnderson" escreveu:
> >
> > > I have a spreadsheet with a column titled current balance. When I enter
> > > costs into other line items and this column updates with the new balance, the
> > > balance shows up in all of the cells below as well. How do I stop that from
> > > happeneing?