Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 16th 05, 11:55 AM
Hazeldean
 
Posts: n/a
Default What is the formula for bank account row balance column

A formula resultong in a balance row to take into account debit & credit
entries

  #2   Report Post  
Old May 16th 05, 12:22 PM
 
Posts: n/a
Default

Hi

You need to take the existing balance and add credits, or subtract debits.
Presumably, on each row you will either have a debit or a credit - but not
both. With your Debits in column B and your Credits in column C, use
something like this in column D
=D2-B3+C3
This will take the previous total (in D2) and subtract or add the necessary
values.
Hope this helps.

--
Andy.


"Hazeldean" wrote in message
...
A formula resultong in a balance row to take into account debit & credit
entries



  #3   Report Post  
Old May 17th 05, 04:34 AM
David McRitchie
 
Posts: n/a
Default

I don't know about you but I occasionally delete a row,
and certainly insert rows. So it would be best not to
refer to the cell above by it's address. See
http://www.mvps.org/dmcritchie/excel/insrtrow.htm

D3: =D2-B3+C3
better written as
D3: =OFFSET(D3,-1,0) - B3 + C3

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

<Andy B wrote in message ...
Hi

You need to take the existing balance and add credits, or subtract debits.
Presumably, on each row you will either have a debit or a credit - but not
both. With your Debits in column B and your Credits in column C, use
something like this in column D
=D2-B3+C3
This will take the previous total (in D2) and subtract or add the necessary
values.
Hope this helps.

--
Andy.


"Hazeldean" wrote in message
...
A formula resultong in a balance row to take into account debit & credit
entries







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with macro formula and variable Huge project Excel Worksheet Functions 0 December 28th 04 01:27 AM
Formula Result Correct but value in the cell is wrong jac Excel Worksheet Functions 2 December 17th 04 08:05 PM
Excel 2003 - Formula result shows as 0:00 Serena Excel Worksheet Functions 4 November 11th 04 10:18 PM
Complex formula help needed Jan Excel Worksheet Functions 0 November 9th 04 03:19 PM
Need Formula Help Jan Excel Worksheet Functions 0 November 8th 04 10:49 PM


All times are GMT +1. The time now is 06:45 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017