Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

Reverse Engineer Formula Result

Collapse
This topic is closed.
X
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2
    Re: The Power Function

    Goal Seek.

    Comment


    • #3
      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.

      Comment


      • #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)

        Comment


        • #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
          Entia non sunt multiplicanda sine necessitate.

          Comment

          Trending

          Collapse

          There are no results that meet this criteria.

          Working...
          X