Automatically distributing quiz scores

With the respective points in C1:I1, C3=$I3*C$1/$I$1, copy across and down.

Originally Posted by josephteh

With the respective points in C1:I1, C3=$I3*C$1/$I$1, copy across and down.

Thank you for your response. However, what I'm looking for is not exactly this. If I do it this way, the scoring system for all those who score 60 will be the same. I want it to be more varied. If out of 700 students, 100 of them score 60, and they all get the same score on the same questions, it could cause a bit of a problem for me