Forum Discussion

Toni Edwards's avatar
Toni Edwards
Copper Contributor
Jan 30, 2018
Solved

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

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    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