View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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