adding and subtracting columns
Assuming you use row 1 for headings, so that your data starts in row 2,
put this formula in cell D2:
=B2-C2
Then in D3, add this formula:
=D2+B3-C3
Then you can copy this formula to other cells in column D and it will
automatically give you the running balance.
Keep reading the posts to these newsgroups - you will quickly pick up
many tips on using Excel.
Hope this helps.
Pete
sierra_louise wrote:
How do I do the following:
Column B (add)
Column C (minus)
Column D (total of A minus B)
example
Column A Column B Column C Column D
Paid In 20.00 20.00
Debit 10.00 10.00
Debit 5.00 5.00
Paid In 150.00 155.00
I need the running balance in Column D - hope someone can help Im trying to
put my accounts on Excel.
Thanks
Sierra_Louise
ps: i need an IDIOTS GUIDE because Im new to Excel
|