Is there a better way to write this grade calculation formula?

[bigtime]

Hello,

The formula I'm using below does give the result I am expecting, but it seems like there should be a much better more efficient way of doing it (math was never my strong suit!!).

I'm assigning a percent score based on the number of steps.

Here's my formula:

$stepGrade = $AVGSteps/(($maxavgsteps-$minavgsteps)/$maxPoints) - $maxPoints

86% = 9300/((10000-5000)/100) - 100

Percent	Average Steps/Day
100	10000
90	9500
80	9000
70	8500
60	8000
50	7500
40	7000
30	6500
20	6000
10	5500
0	5000

Thanks for any feedback!

Tim

 

[bigtime]

Thank you for your reply! Much appreciated!