How to Convert Number Grades to Letter Grades in Excel

In this video, I'll show you the easiest way to convert number grades to letter grades in Microsoft Excel.

This could be done with a number of IF statements, but a much easier way to do it is with a VLOOKUP.

If you find my Microsoft Excel tutorial videos informative, please give this video a thumbs up.

Please consider subscribing as it will really help my channel grow and you'll get access to subscriber-only live streams where I will answer your questions live!:

☑️ About the Excellent Dude Microsoft Excel Tutorials
I create a wide variety of Microsoft Excel tutorials to help beginners all the way to advanced users.

#excelhowto #exceltutorials #learnexcel

[herdityawahyu]

Got stuck several times, getting F for all grades. The solution is that the scoring table array - just like in this video - must be sorted/ordered from the LOWEST to the HIGHEST scores/grades. My mistake was that my scoring table array was sorted from the highest to the lowest... that's why I am getting all F... nice vid man, thanks!

[scottblazicek]

Best example for What I was looking for!!! Thanks!

[ronaldlawrence]

Worked great! Thanks Made my work a lot easier

[dariknour]

First of all thank you sir. One thing, if I write a score of lets say 120, it returns an 'A'. So, how can fix the rage between 0-100?

[markrationalthinker]

Cannot get this to work. Set it up exactly as you have it, but with a -/+ extended scale in the letter grade column. Anything that falls on the border is scored as the next lower grade: e.g., 93 should be an A, but is scoring as an A- and the range for A- is 90-92, with 90 entered in the center column.

[onyedikachukwundimako]

Did anyone get an F all the way... don't know what's happening with mine😅

[cardboardmusic]

Tried it several times, but never worked, so I gave up.