I need a formula for grading systems based on these percentages. 1 is the optimal system, 5 is the least optimal. I need a percentile formula and an IF statement


0-20 % (1)

21-40% (2)

41-60% (3)

61- 80% (4)

81-100% (5)

Cheers