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
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
=IF( cell<=0.2 , 1, IF(cell<=0.4,2, IF( cell<=0.6, 3, IF(cell<=.8, 4, 5))))
if the % is in cell A1
=IF(A1<=0.2,1,IF(A1<=0.4,2,IF(A1<=0.6,3,IF(A1<=0.8,4,5))))
With your percentage in A1
=LOOKUP(A1,{0,0.21,0.41,0.61,0.81},{1,2,3,4,5})
does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks