Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

# Thread: Reverse Engineer Formula Result

1. Member
Join Date
13th January 2005
Posts
53

## Reverse Engineer Formula Result

Hello there

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.

BR
Dich Stoffer, Denmark

Excel Video Tutorials / Excel Dashboards Reports

2. ## Re: The Power Function

3. Member
Join Date
13th January 2005
Posts
53

## Re: Reverse Engineer Formula Result

Thx Dave

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.

Excel Video Tutorials / Excel Dashboards Reports

4. ## Re: Reverse Engineer Formula Result

If A1 contains a positive number and B1 contains

=POWER(A1,x)

then if you use this formula in C1 it returns A1

=POWER(B1,1/x)

Excel Video Tutorials / Excel Dashboards Reports

5. ## Re: Reverse Engineer Formula Result

=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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•
porno