C
cindi
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
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