Forum Discussion
Toni Edwards
Jan 30, 2018Copper Contributor
Please can someone help me with a formula?
I don't even know the maths I need to work this out...
But I have a cost per KM at a start point, and then I know that the cost increases x% per month, and I have an average KM per month... How do I work out what the cost would be at specific points during a term of x months?
I think this is more of a maths question than an Excel question, but I need to use the formula of this to get the answers for several different instances of this question.
Any help would be huuuuugely appreciated!
- Suppose your # months is in cell A1, the monthly increase is in A2 and the starting rate is in A3. The new rate then equals (formula to go into -say- cell A4):
=A3*(1+A2)^A1
1 Reply
- JKPieterseSilver ContributorSuppose your # months is in cell A1, the monthly increase is in A2 and the starting rate is in A3. The new rate then equals (formula to go into -say- cell A4):
=A3*(1+A2)^A1