How to hide running total in successive cells in a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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:
 
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.
 
thanks for the feedback, sorry for the ; (semicolon) we use it here in Brazil

regards

"JenniferAnderson" escreveu:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Running Balance in Access 1
I want a cell to show total from other cell when that cell changes 6
Trying to either hide data in a cell or reduce the data to zero 2
Hide blank data 4
How can cell entries be based on word entries in another cell ? 1
General ledger spreadsheet continued 2
First row where a cell is zero 1
Access How to calculate the balance carried forward of individual student when payment of fee is made in ms access 2013 1

Back
Top