I've look online and find what seems to be the right formula but I keep getting #N/A. the formula i'm using is
=VLOOKUP(N3,$R$5:$S$10,S6:S10)
The final grades are in column N
The grade ranges are R6:R10
Letter Grades S6:S10
Not sure if the the grade ranges per cell are creating the issue. Example cell R6 is 60-0.
=VLOOKUP(N3,$R$5:$S$10,S6:S10)
The final grades are in column N
The grade ranges are R6:R10
Letter Grades S6:S10
Not sure if the the grade ranges per cell are creating the issue. Example cell R6 is 60-0.