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...
Formulas & Functions
Need Help
  • JKPieterse's avatar
    JKPieterse
    Jan 30, 2018
    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
JKPieterse's avatar
JKPieterse
Silver Contributor
Jan 30, 2018
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