+ Reply to Thread
Results 1 to 7 of 7

Calculate a percentage between a range of percentages

  1. #1
    Registered User
    Join Date
    05-30-2022
    Location
    Portugal
    MS-Off Ver
    2016
    Posts
    4

    Calculate a percentage between a range of percentages

    Hello everybody,

    I need to calculate the percentage of a value, within a range of values, where the minimum value is an x% and the maximum value is a y%.

    For example, 90 (minimum value) is equivalent to 90% and 100 (maximum value) to 100%.
    I know that 95 will be equivalent to 95%, but how do I calculate in excel so that I can change the value of the minimum and maximum percentages? Example, if 90 becomes 20%, and 100 becomes 50% how much it will be 95 in%?

    Thank you,

  2. #2
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365
    Posts
    2,716

    Re: Calculate a percentage between a range of percentages

    Hi,
    why cant you just type 20 instead of 90 (and format the cell to show percentage) ?

  3. #3
    Registered User
    Join Date
    05-30-2022
    Location
    Portugal
    MS-Off Ver
    2016
    Posts
    4

    Re: Calculate a percentage between a range of percentages

    I'm the one who gives the 20% (for 90).
    But how much is 95 in percentage if 90 equals to 20%?

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,501

    Re: Calculate a percentage between a range of percentages

    20 = 90%

    95 = (95/90)*20

    The result is 21,11
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  5. #5
    Registered User
    Join Date
    05-30-2022
    Location
    Portugal
    MS-Off Ver
    2016
    Posts
    4

    Re: Calculate a percentage between a range of percentages

    Thanks for the support, but it's not what I need.

    What I need is to calculate is the percentage between a range. If 20 equals to 90%, and 50 equals to 95%, how can I calculate in Excel the percentage of 43?

  6. #6
    Registered User
    Join Date
    03-01-2022
    Location
    Eire
    MS-Off Ver
    O365
    Posts
    37

    Re: Calculate a percentage between a range of percentages

    Your explanation is not at all clear. Maybe...


    =B1+(C1-B1)*(B4-B2)/(C2-B2)
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    05-30-2022
    Location
    Portugal
    MS-Off Ver
    2016
    Posts
    4

    Re: Calculate a percentage between a range of percentages

    Thank you so much!

    That's exactly what I needed

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 11-28-2019, 09:23 AM
  2. [SOLVED] Formula help to calculate stepped commission percentage in a range
    By Thatguy99 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-22-2019, 03:49 AM
  3. Replies: 6
    Last Post: 12-14-2017, 01:11 AM
  4. How to work out a percentage from a range of percentages?
    By DannyWinning in forum Excel General
    Replies: 2
    Last Post: 01-14-2014, 10:50 AM
  5. Calculate percentage of specific date range
    By grahto in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-25-2013, 06:39 AM
  6. Calculate highest percentage of 2 pairs between a range
    By sans in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-24-2012, 12:03 PM
  7. Macro to calculate range by a percentage
    By judasdac in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-26-2009, 06:11 PM

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