Results 1 to 2 of 2

Thread: Reverse Square Root...

  1. #1

    Default Reverse Square Root...

    Ok I am lamost bald on trying to figure this one out. I have a formula that uses the sqaure root to come up with a number. Here is the formula...

    Sqrt(7)*0.845+8.96 the result is 11.20. Now what I need to do is take the answer and back track to the 0.845. Basically I need to be able to use any number like 11.20 and have it come up with the rate. Make sense?

    Another way to say it. The base is 8.96 in seven years they get to a mid point of 11.20. So:


    Years = 7
    Rate = 0.845
    Base = 8.96
    Midpoint = 11.20

    When you use the function the rate changes based on the midpoint and base numbers. The base is always 20% less than mid.

    I hope this makes sense and someone can help.

  2. #2
    MrExcel MVP
    barry houdini's Avatar
    Join Date
    Mar 2005

    Default Re: Reverse Square Root...

    To get the rate


    or given that Base is always 20% of Midpoint you can simplify to

    Last edited by barry houdini; Jul 3rd, 2008 at 07:26 PM.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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