# Calculate a percentage between a range of percentages

1. ## 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. ## 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. ## 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. ## Re: Calculate a percentage between a range of percentages

20 = 90%

95 = (95/90)*20

The result is 21,11

5. ## 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. ## Re: Calculate a percentage between a range of percentages

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

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

7. ## Re: Calculate a percentage between a range of percentages

Thank you so much!

That's exactly what I needed

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

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