Formula help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a formula in excel that calculates total savings with fixed increasing
payments.

e.g.
Month 1, deposit into savings $10, total $10
Month 2, deposit into savings $20, total $30
Month 3, deposit into savings $30, total $60

I need a formula that allows me to show the result of $60 in a cell when the
user enters 3 payments starting with $0, incrementing by $10.

(my example is not the actual use, but demonstrates what I need)
 
Suppose the savings is entered starting in A1... and the total is in B1

In B1 put

=A1

In B2 put

=A2+B1

And then copy B2 and paste it all the way down to the bottom. If I'm reading
what you are saying right.

And if its always increments of 10, in A2 put A1+10 and then copy and paste
that down column A.
 
Let's say you enter your savings #'s in A1, A2, A3, etc. To get the
cumulative #, try this

= SUM(A$1:A1)

and copy down as needed.

HTH,
Barb Reinhardt
 
I appreciate your response but that is what I am doing currently. I am
looking for a formula to simply my spreadsheet.
 
I appreciate your response but that is what I am doing currently. I am
looking for a formula to simply my spreadsheet.
 
If I understand well that you would like to know the final total after M
months, with an increment of I, the formula for the total would be
I*M*(M+1)/2, in other words:
If for instance the cell A1 contains the number of months, and cell B1 the
amount of increment, and C1 should indicate the final total, the formula in
C1 would be:

=B1*A1(A1+1)/2

This would result as the total after (B1) payments, in your example:
10*3*(3+1)/2 = 60

or would you like something else?

Kind regards,
Erny
 
Back
Top