| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bank balance type of formula
I have a spreadsheet that I need a bank balance type of formula, and I can't
figure out what i am doing wrong....... Column B: deposits Column C: withdrawals Column D: top cell only with account balance, a formula which ADDS any amounts placed into column A, and subracts any amounts put into column B. This is what I am using as my formula in the Column D cell, which is obviously not correct: =+(B13:B171)-(C13:C171) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Bank balance type of formula
One way:
=SUM(B13:B171)-SUM(C13:C171) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "DonnaR" wrote in message ... I have a spreadsheet that I need a bank balance type of formula, and I can't figure out what i am doing wrong....... Column B: deposits Column C: withdrawals Column D: top cell only with account balance, a formula which ADDS any amounts placed into column A, and subracts any amounts put into column B. This is what I am using as my formula in the Column D cell, which is obviously not correct: =+(B13:B171)-(C13:C171) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Bank balance type of formula
THANK YOU!
"RagDyeR" wrote: One way: =SUM(B13:B171)-SUM(C13:C171) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "DonnaR" wrote in message ... I have a spreadsheet that I need a bank balance type of formula, and I can't figure out what i am doing wrong....... Column B: deposits Column C: withdrawals Column D: top cell only with account balance, a formula which ADDS any amounts placed into column A, and subracts any amounts put into column B. This is what I am using as my formula in the Column D cell, which is obviously not correct: =+(B13:B171)-(C13:C171) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Bank balance type of formula
first, your description of column D says A is depostits but there is no
description of A and the formula references B & C so I'll assume the description of D is wrong. second, you are not referencing the opening balance. third,do you only want a final balance or a running balance? assuming the data looks like: B C D 0 0 500 10 0 0 20 the formula in D3 could be "=D1+sum(B1:B3)-sum(c1:C3)" or the formula in D2 cell could be "'=D1+B2-C2" and then copy down the column "DonnaR" wrote: I have a spreadsheet that I need a bank balance type of formula, and I can't figure out what i am doing wrong....... Column B: deposits Column C: withdrawals Column D: top cell only with account balance, a formula which ADDS any amounts placed into column A, and subracts any amounts put into column B. This is what I am using as my formula in the Column D cell, which is obviously not correct: =+(B13:B171)-(C13:C171) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do you subtract from the bank balance | Excel Discussion (Misc queries) | |||
| rent received/balance owed/running balance spreadsheet | Excel Discussion (Misc queries) | |||
| automatic entering Balance at every entry in my bank account | Excel Discussion (Misc queries) | |||
| What is the formula for bank account row balance column | Excel Worksheet Functions | |||
| I want a running balance like a bank statement | New Users to Excel | |||
Linear Mode
