I'm making a small table in Excel to calculate the increase between 2 levels in different ways. There's one that I can't get solved. I think it's a mathematical problem, but I can't find out what's wrong with it.
It's about the number of steps it takes for something to increase to another level if the increase per step is constant.
Example:
Start = 5,000
End = 25,272
% = Inrease per step = 10% = 0.1
Number of steps = (Start / End) ^ (1 / (1 + %)) <-- (I think the error is in here)
= 5.054 ^ 0.909
= 4.36
In Excel:
A1 = Start: 5,000
B1 = End : 25,272
D1 = % increase per step: 10% = 0.1
C1 = number of steps = (B1/A1)^(1/(1+D1))
The problem is that the answer should be 17.
What should the right formula be to solve the problem?
2006-10-29
01:09:31
·
5 answers
·
asked by
JB
1
in
Mathematics