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

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!