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

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
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
 
Upvote 0
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>
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,144
Members
448,552
Latest member
WORKINGWITHNOLEADER

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
Back
Top