How do I bill amounts once an initial amount has been used up.

  • Thread starter Thread starter Ed Bostelmann
  • Start date Start date
E

Ed Bostelmann

I am having a problem trying to work out how to setup a
spreadsheet to bill amounts once an initial amount has
been used up.

Let me explain - if at the beginning of the year you put
aside £1000 - and each month you use up some of the
amount, say after 7 months you have only £50 left, and
the 8th month you use £100, I am wanting have a
spreadsheet that bills £50 for the 8th month and then
bills for all the other months for the remainder of the
year as the initial amount has been used. The initial
amount could be used up in any month.

I hope this explains it.

Ed
 
Assuming the 1000 is in cell c1 and the amount used starts in cell c3:c15.
Put this formula in d3 and copy down.

=SUM($C$3:C3)-$C$1
1000
1 used due
2 100 -900
3 100 -800
4 100 -700
5 100 -600
6 100 -500
7 100 -400
8 100 -300
9 100 -200
10 100 -100
11 100 0
12 100 100
13 100 200

--
Don Guillett
SalesAid Software
(e-mail address removed)
message I am having a problem trying to work out how to setup a
spreadsheet to bill amounts once an initial amount has
been used up.

Let me explain - if at the beginning of the year you put
aside £1000 - and each month you use up some of the
amount, say after 7 months you have only £50 left, and
the 8th month you use £100, I am wanting have a
spreadsheet that bills £50 for the 8th month and then
bills for all the other months for the remainder of the
year as the initial amount has been used. The initial
amount could be used up in any month.

I hope this explains it.

Ed
 
Back
Top