Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Reverse Engineer Formula Result

  1. #1
    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.

    Thx in advance for any reply.

    BR
    Dich Stoffer, Denmark

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,715

  3. #3
    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. #4
    Join Date
    24th April 2007
    Location
    England
    Posts
    675

    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. #5
    Join Date
    12th September 2006
    Location
    The Great State of Texas
    Posts
    4,323

    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
    Entia non sunt multiplicanda sine necessitate.
    MS MVP - Excel

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Reverse Engineer Formula Dependencies
    By Leisim98 in forum EXCEL HELP
    Replies: 6
    Last Post: December 17th, 2007, 03:14
  2. Reverse Calculation Of Formula
    By bahareh in forum EXCEL HELP
    Replies: 2
    Last Post: October 9th, 2007, 22:19
  3. Copy Formula Result & Paste Value/Result Only
    By Jeff P in forum EXCEL HELP
    Replies: 2
    Last Post: September 3rd, 2006, 14:26

Bookmarks

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