help.. too difficult to put into words

A

Alexis

I have a bunch of percentages that are on a 100% scale, but i need to create
a formula in excel that would scale it down to a 60% scale.

for example i need create a function that would prevent 89.72% from
exceeding 60%, i know the answer is 53.83%, but i don't know how to come up
with to formula to calcualte that.

im guessing i would use an IF THEN formula, =IF, but im not for sure.

your help is appreciated. thanks!!
 
D

Dave Peterson

Maybe just taking 60% of your result would be enough???

If A1 held the original value:
=60%*a1

or just
=60%*(YourOriginalFormulaInA1Here)
 
B

bpeltzer

It looks like you just multiplied the input (89.72% in your example) by .6.
That would map the range 0-100% down to 0-60%. If your input is in A1, then
=a1*.6, formatted as a percent, would do this.
 
Top