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!