Formula Question

[Mike Davis]

How do I add a value in a cell to itself to get a cumulative total? i.e.
Revenue..10000..Value input each month
Bonus......500..=B1*5%..Changes mthly with Revenue.
Bonus Hold Back..100..=B2*20%..Changes mthly with Revenue. Want to add this to itself each month to have cumulative total at end of year.

[Yogi Anand]

On 2002-04-20 07:58, Mike Davis wrote:
How do I add a value in a cell to itself to get a cumulative total? i.e.
Revenue..10000..Value input each month
Bonus......500..=B1*5%..Changes mthly with Revenue.
Bonus Hold Back..100..=B2*20%..Changes mthly with Revenue. Want to add this to itself each month to have cumulative total at end of year.

If I have understood you correctly ...
Let us say the revenue of 10000 is entered in cell A1, Bonus at 5% is entered in cell B1, Bonus holdback of 20% is in cell B2,
then in A2 enter the following formula

=A1+B1-B2 to get 10400

or you could alternatively enter

=A1*(1+0.05-0.05*.2) which simplifies to

=A1*(1+0.04)

HTH

[mrpharmacist]

Have a mess about with this, I couldn't think of a straight formward formula.

Sub RunningTotal()

'Define the variables
'Re = Revenue Bo = Bonus
'BoHoBa = Bonus Hold Back and RuTo = Running Total

Dim Re As Integer, Bo As Integer, _
BoHoBa As Integer, RuTo As Integer

'Input the "Revenue"
Re = InputBox(prompt:="Revenue")

'Do the maths
Bo = Re * 0.05
BoHoBa = Bo * 0.2
RuTo = Range("A4").Value + BoHoBa

'Display the result
Range("A1") = Re
Range("A2") = Bo
Range("A3") = BoHoBa
Range("A4") = RuTo

End Sub