Help! With new percentage of a number within limits

apoland44

New Member
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
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
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
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

Replies
3
Views
603
Replies
3
Views
374
Replies
1
Views
517
L
Replies
2
Views
2K
Legacy 206451
L
Replies
4
Views
911

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.

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.

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

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