Help! With new percentage of a number within limits

[apoland44]

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!

 

[AhoyNC]

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
	C	D
2	90%	92.70%
Sheet

 

[Teeroy]

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;

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]
[TABLE="width: 100"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent"]Band
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 100"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent"]Multiplier
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]
[TABLE="width: 100"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent"]0-80
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 100"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]
[TABLE="width: 100"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent"]80.001-85
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 100"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent, align: right"]1.05
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]
[TABLE="width: 100"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent"]85.001-90
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 100"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]
[TABLE="width: 100"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent"]90.001-95
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 100"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent, align: right"]1.03
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]
[TABLE="width: 100"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent"]>95
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 100"]
<tbody>[TR]
[TD="width: 100, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[apoland44]

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
	C	D
2	90%	92.70%
Sheet

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