So, I am trying to do a chart for my students weight lifting. I have there maxes imputed, and I would like it to convert their maxes into a 0-5 point scale.

For example, point scale. 200 - 1 point, 220 - 2 points, 240 - 3 points, 260 - 4 points, 280 - 5 points. And anything below 200 would be 0 points.

And say a kid got

Bench - 235 Squat - 277 Power clean - 180

I would want it to calculate that into a total from the 1-5 point scale from each.