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?

How to hide running total in successive cells in a column
 

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?

How to hide running total in successive cells in a column
 

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?

How to hide running total in successive cells in a column
 

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?