Remember Me?

#1
May 16th 05, 11:55 AM
 Hazeldean Posts: n/a
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
May 16th 05, 12:22 PM
 Posts: n/a

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
May 17th 05, 04:34 AM
 David McRitchie Posts: n/a

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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Huge project Excel Worksheet Functions 0 December 28th 04 02:27 AM jac Excel Worksheet Functions 2 December 17th 04 09:05 PM Serena Excel Worksheet Functions 4 November 11th 04 11:18 PM Jan Excel Worksheet Functions 0 November 9th 04 04:19 PM Jan Excel Worksheet Functions 0 November 8th 04 11:49 PM

All times are GMT +1. The time now is 07:11 PM.