Hello,
I am marking my students grades Is they a formula that will automatically put the grade in if a criteria is met for example
0-10 = U
11-15 - G
16 - 20 =F
21-25 = E
......
65+ = A*
Thank you in advance
Steve
Hello,
I am marking my students grades Is they a formula that will automatically put the grade in if a criteria is met for example
0-10 = U
11-15 - G
16 - 20 =F
21-25 = E
......
65+ = A*
Thank you in advance
Steve
Last edited by slock92; 02-22-2017 at 01:38 PM. Reason: Solved
Amusing the criteria is in A1 use this
Add other levels in the similar fashion.=IF(A1<=10,"U",IF(A1<=15,"G",IF(A1<=20,"F",IF(A1<=25,"E"))))
Teach me Excel VBA
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks