+ Reply to Thread
Results 1 to 2 of 2

Progressive function

  1. #1
    Registered User
    Join Date
    04-13-2012
    Location
    Kiel
    MS-Off Ver
    Excel 2003
    Posts
    2

    Progressive function

    I'm trying to figure out a protected formula. Following data:

    2.00 - 2.00
    1.90 - 2.11
    1.80 - 2.25
    1.70 - 2.43
    1.60 - 2.67
    1.50 - 3.00
    1.40 - 3.50
    1.30 - 4.33
    1.20 - 6.00
    1.10 - 11.00

    I'm sure there's a (quite simple) formula for this, but I can't seem to get my head straight on this. Can anybody tell me the formulas for both directions?

    Thanks.

  2. #2
    Registered User
    Join Date
    04-13-2012
    Location
    Kiel
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Progressive function

    Never mind, figured it out myself. For those interested:

    A1=+B1/(B1-1)
    B1=1/(A1-1)+1

    Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1