Help! With new percentage of a number within limits

apoland44

New Member
Joined
Dec 3, 2015
Messages
2
Im working on a spread sheet for work regaring satifaction scores. All scores are shown in percentages. What I am trying to do is come up with an equation that will tell me how much the site needs to go up by IF within a certain percentage range.
Example:
I have scores of;
92.25%
94.90%
82.25%
98.00%
now what I need to happen in the next column is for it to find the new percentage but only if the original percent is within a certain range. SO:
If the original percent was within 80-85 I need it to increase by 5 percent.
If the original percent was within 90-95 I need it to increase by 3 percent.
-etc with more limits, but you get the jist.
What I have so far is:
=PRODUCT(C2*0.03+C2) this is giving me a new percent but its fixed to 3 percent.
-What if C2 fell in a different range, lets say 80-85, now I need the increase to be 5 percent not 3.
Is it posible to make such an in depth equation with so many limits?
Any and all help is greatly appreciated!
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

AhoyNC

Well-known Member
Joined
Oct 10, 2011
Messages
4,883
Office Version
  1. 365
Platform
  1. Windows
You could do something like this:
Say under 80% you want to increase by 7%,
80%-85% increase by 5%
You didn't say what 86%-89% should be, so in this example 86 to 95% go up by 3%.
Excel Workbook
CD
290%92.70%
Sheet
 

Teeroy

Well-known Member
Joined
Nov 9, 2012
Messages
2,244
Office Version
  1. 365
Platform
  1. Windows
Hi and welcome to the forum.

Try the following and adjust the bands as required.

=C2*LOOKUP(100*C2,{0,80,85.001,90.001,95;1,1.05,1,1.03,1})

The above has the following bands;


Band

<tbody>
</tbody>

Multiplier

<tbody>
</tbody>

0-80

<tbody>
</tbody>

1

<tbody>
</tbody>

80.001-85

<tbody>
</tbody>

1.05

<tbody>
</tbody>

85.001-90

<tbody>
</tbody>

1

<tbody>
</tbody>

90.001-95

<tbody>
</tbody>

1.03

<tbody>
</tbody>

>95

<tbody>
</tbody>

1

<tbody>
</tbody>

<tbody>
</tbody>
 

apoland44

New Member
Joined
Dec 3, 2015
Messages
2
You could do something like this:
Say under 80% you want to increase by 7%,
80%-85% increase by 5%
You didn't say what 86%-89% should be, so in this example 86 to 95% go up by 3%.
Excel Workbook
CD
290%92.70%
Sheet


Thank you! I will try this one on my spread sheet. Looks promising
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,151,844
Messages
5,766,744
Members
425,378
Latest member
kapoor2892

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top