Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula for an Excel spreadsheet
Using Microsoft Excel, I am listing columns of figures, items in,
followed by items out, although not necessarily in that order. I need a formula that will allow me to use another column as a running balance, similar to the details shown in a bank statement, so that the current balance is shown at every line. Any assistance will be greatly appreciated Barry |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula for an Excel spreadsheet
Excel comes with some built-in sample templates. Have you looked at the one
called Ledger? It may help you get started "Lorraine" wrote: Using Microsoft Excel, I am listing columns of figures, items in, followed by items out, although not necessarily in that order. I need a formula that will allow me to use another column as a running balance, similar to the details shown in a bank statement, so that the current balance is shown at every line. Any assistance will be greatly appreciated Barry |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula for an Excel spreadsheet
Assuming your table has the following structu
Col A......Col B......Col C......Col D Item......Items In......Items Out......Balance and, assuming that your first row is a header row like above, and, assuming that the values for "Items In" and "Items Out" are both positive, you would do the following: 1) In the first available row (row 2 after the headings), you'd insert your starting balance only (no transactional data) in the appropriate column ("D" in this example) 2) In the cell below that ("D3" in this example), you'd insert the following formula: =A2+B3-C3 3) Copy and paste that formula down throughout the remainder of your table. If your "Items Out" column shows negative values, then change the first formula to: =A2+B3+C3 -Glenn Ray MOS Master "Lorraine" wrote: Using Microsoft Excel, I am listing columns of figures, items in, followed by items out, although not necessarily in that order. I need a formula that will allow me to use another column as a running balance, similar to the details shown in a bank statement, so that the current balance is shown at every line. Any assistance will be greatly appreciated Barry |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula for an Excel spreadsheet
Ack...can't even get a simple formula right!
The formula in step 2 should read "=D2+B3-C3" and the alternate formula should be "=D2+B3+C3" (NOT "A2"). "Glenn Ray" wrote: Assuming your table has the following structu Col A......Col B......Col C......Col D Item......Items In......Items Out......Balance and, assuming that your first row is a header row like above, and, assuming that the values for "Items In" and "Items Out" are both positive, you would do the following: 1) In the first available row (row 2 after the headings), you'd insert your starting balance only (no transactional data) in the appropriate column ("D" in this example) 2) In the cell below that ("D3" in this example), you'd insert the following formula: =A2+B3-C3 3) Copy and paste that formula down throughout the remainder of your table. If your "Items Out" column shows negative values, then change the first formula to: =A2+B3+C3 -Glenn Ray MOS Master "Lorraine" wrote: Using Microsoft Excel, I am listing columns of figures, items in, followed by items out, although not necessarily in that order. I need a formula that will allow me to use another column as a running balance, similar to the details shown in a bank statement, so that the current balance is shown at every line. Any assistance will be greatly appreciated Barry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula for excel spreadsheet | New Users to Excel | |||
Excel TCP/IP spreadsheet formula help | Excel Discussion (Misc queries) | |||
Excel spreadsheet formula | Excel Worksheet Functions | |||
Urgent - how to set a formula in excel spreadsheet | Excel Worksheet Functions | |||
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) |