Formula Needed

  • Thread starter Thread starter lsmith
  • Start date Start date
L

lsmith

I am doing a spreadsheet where I am keeping a running, -decreasing
balance in a column, with the figures that will be subtracted i
another column. How do I create a formula to show the balance? Th
cells in the one column somehow need to be linked to that balance, bu
utilizing the original number from which they are being subtracted.
HELP! and many thanks! I need this ASAP
 
If A1=balance before any subtactions and column B contains the numbers
to be subtracted (starting in B2), the a simple formula could be:

A2=A1-B2
A3=A2-B3
A4=A3-B4
...

I'm not sure if this is what you had in mind, please clarify if your
problem is more complicated
 

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

HELP!!! I need to make a simple formula! 6
subtracting in Excel 2
Multi-demensional frequency distribution 4
Paste without overwriting formulas 1
Total formula 1
Running Balance in the same cell... 2
Balances 6
Data format 1

Back
Top