Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculate Remaining Balance
I need to create a formula that refers to a remaining
balance. The form is a Account Statement and has the following columns: Date Transaction Amount Balance 1/2/04 Inv.# 123 89.23 89.23 1/10/04 Inv.# 124 50.87 140.1 1/21/04 PMT -60.00 80.10 Amt. Due ????? How do have excel automatically calculate the amount due? Any help would be greatly appreciated. Thanks! Cindi |
#2
|
|||
|
|||
Since the invoices are positive numbers and the payments are negative you
could just sum the Amount column. =sum(c2:c??) "cindi" wrote in message ... I need to create a formula that refers to a remaining balance. The form is a Account Statement and has the following columns: Date Transaction Amount Balance 1/2/04 Inv.# 123 89.23 89.23 1/10/04 Inv.# 124 50.87 140.1 1/21/04 PMT -60.00 80.10 Amt. Due ????? How do have excel automatically calculate the amount due? Any help would be greatly appreciated. Thanks! Cindi |
#3
|
|||
|
|||
Since you enter payment with negative values you can just sum the amount column
=SUM(C2:C10) Regards, Peo Sjoblom "cindi" wrote: I need to create a formula that refers to a remaining balance. The form is a Account Statement and has the following columns: Date Transaction Amount Balance 1/2/04 Inv.# 123 89.23 89.23 1/10/04 Inv.# 124 50.87 140.1 1/21/04 PMT -60.00 80.10 Amt. Due ????? How do have excel automatically calculate the amount due? Any help would be greatly appreciated. Thanks! Cindi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I calculate EDATE using days not months? | Excel Discussion (Misc queries) | |||
how : check register running balance is a stationary cell | Excel Discussion (Misc queries) | |||
Not able to calculate. | Excel Worksheet Functions | |||
calculate percent increase | Excel Discussion (Misc queries) | |||
How do you calculate the nth root of a number in Excel 2003? | Excel Worksheet Functions |