I assumed that may be the issue, but it doesn't explain how your userform will be helpful.
As there is only one set of data in the worksheet, and it is arranged in a column instead of the row that might be helpful if accompanied by other students results, it is difficult to see where you are going with this.
What you need is a row for each student and then you can put the function in Column 5 (with some modifications) and drag to fill the column (or use autofill as in the attached) and set the values.

Attached Files

Example.xlsx (8.7 KB, 10 views)

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com