Hi There,

Hoping that you can help, I need a pro rata formula which I am struggling with at the moment.

Basically I need to pro rata a score between 0% and 2% with 0% equals to 60% and anything over and above 0% upto 2% pro rata to 100%. but then in the same formula I need to take from anything over 2% and between 5% pro rata from 100% to 120% and then anything over 5% capped at 120%

Thanks for your help in advance on this, Ive been struggling for about 2 days.

Best Regards