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!!