Formula to evaluate the output of a calculation and to determine a score according to a range
I am currently setting up a scorecard where the individual is allocated points based on % achievements within specific ranges, and would really appreciate some help in formularizing the allocation of points (score) based on the % achievement
For example - In the example below. an Achievement of 93% will score 20 points, 105 % will score 40 points..etc
looking forward to your thoughts
Help Article Resources
Check out the Formula Handbook template!