Probably an easy question:
If I use this formula "=POWER(1,02;3)" I raise the number 1,02 to the power of 3, and the result is 1,061208.
Now, if I know the result 1,061208 and the value 3, which formula do I then use to find back to the value 1,02.
Thx in advance for any reply.
Dich Stoffer, Denmark
I don't think goal seek solves my problem.
Forget my first question and the numbers and what I wrote about POWER function - I shall rephrase ...
Let's say I have the value 8% in a cell, and that I know that the 8% is the growth rate over 3 years.
In my case the growth in the individual years is different, but I want to figure out the average annual growth over the 3 years.
Can you fix that? Thx very much for your help.
BR Dich Stoffer, Denmark.
=POWER(a, x) is just the verbose way of computing =a^x. And =a^x^(1/x) = a^(x/x) = a^1 = a.
So for your specific numbers =1,061208^(1/3) = 1.02
Entia non sunt multiplicanda sine necessitate.
MS MVP - Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)