Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Formula Result Correct but value in the cell is wrong | Excel Worksheet Functions | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions | |||
Complex formula help needed | Excel Worksheet Functions | |||
Need Formula Help | Excel Worksheet Functions |