Grade percent

[Thomas Kuriakose]

Respected Sirs,

Kindly find attached a grading sheet where the percent score needs to be graded. We are able to grade for values until 100%.

For grading score greater than 100% the requirement is to add one point to every 5% increase from 100%.

Kindly guide on how to add this variable in the existing formula to get the new grades for scores greater than 100%.

Thank you very much for your support always,

wit regards,
thomas

 

[vletm]

Thomas Kuriakose
write to cell E1 80%
write to cell B1 =IF([@Score]>E$1,ROUNDUP(([@Score]-E$1)/5%,0),0)
copy previous formula down as needed

 

[Thomas Kuriakose]

Respected Sir,

Thank you very much for the solution provided.

Much appreciated,

with regards,
thomas

 

[bosco_yip]

Or,

In B2, copied down

=IF(A2<0.81,0,MIN(35,INT((A2-0.81)/5%)+1))

Regards
Bosco

 

[Thomas Kuriakose]

Respected Sir,

Thank you very much for this solution and your support.

Much appreciated,

with regards,
thomas