Formula help

[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)

 

[Guest]

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.

 

[Guest]

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

 

[Guest]

I appreciate your response but that is what I am doing currently. I am
looking for a formula to simply my spreadsheet.

 

[Guest]

I appreciate your response but that is what I am doing currently. I am
looking for a formula to simply my spreadsheet.

 

[Gord Dibben]

Clay

Are you looking for an "accumulator" cell so's you can keep adding to it?

See JE McGimpsey's site for info on that.

Note the caveats about not having an audit trail if you go this way.

http://www.mcgimpsey.com/excel/accumulator.html


Gord Dibben MS Excel MVP

 

[Erny]

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

 

[Guest]

Thank you Erny, that is exactly what I was looking for.