Hello,
I have a problem - which I believe to be much more mathematical than a formula in Excel.
I have a list with percentages of results and I need to "stagger" those values according to two known points.
o MINIMUM VALUE = 25 POINTS
o MAXIMUM VALUE = 99 POINTS
and there all the values between must be staggered according to these two references.
I know if it was only the Maximo value (or just the minimum) - a rule of three would be enough to stagger everything.
ex:
MAXIMUM VALUE = 54% = 99 POINTS.
then to 50% - in a three-rule - 91.67 points.
the formula being:
X = (99 x 50) / 54
My question is how to achieve the scale if we have tb the MINIMUM VALUE ..
for example
MAXIMUM VALUE = 54% .... 99 POINTS
MINIMUM VALUE = 12% .... 25 POINTS
How many points are worth 42%? 23%?
I swear I'm burning the cunt .. kkkkk
Thank you Daniel