How to Convert Number Grades to Letter Grades in Excel

No video

How to Convert Number Grades to Letter Grades in Excel

Рет қаралды 9,242

Жыл бұрын

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!:
SUBSCRIBE: www.youtube.co...
☑️ 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

Пікірлер: 17

@scottblazicek7369 9 ай бұрын

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

@ExcellentDude 9 ай бұрын

Glad it was helpful!

@herdityawahyu1250 8 ай бұрын

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!

@pratyushpillai 6 ай бұрын

great video + your comment was really helpful. thank you both :)

@ronaldlawrence8777 4 ай бұрын

Worked great! Thanks Made my work a lot easier

@ExcellentDude 4 ай бұрын

Glad it helped

@onyedikachukwundimako4399 Жыл бұрын

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

@cardboardmusic 8 ай бұрын

Indeed I did. I gave up in the end, I spent too much time wasting precious time. However, I stuck at it and discovered that actually it's much easier (and makes as much sense) to use the IFS function. Also, if you're getting just Fs, check the syntax, I realsied the when you follow tutorials who use a comma ( , ) it doesn't work, you need a semi-colon ( ; ). Or, easier still use the add function button if in doubt.

@dariknour6051 6 ай бұрын

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 8 ай бұрын

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.

@nkirotemwaria6135 10 ай бұрын

Also only seeing Fs all the way down.

@ExcellentDude 10 ай бұрын

Hi there - the key is to make sure when you reference the scoring table on the right (in my video), to use absolute references (noted by $ signs) otherwise when you copy the vlookup formula to other rows, the vlookup will shift what it's looking at which will give incorrect results. Here's an example with absolute references - hopefully this is why your results aren't working (=vlookup(C4,$G$4:$H$8,2,FALSE). Let me know if this was the issue - if not, add your formula to the comments.

@cardboardmusic 8 ай бұрын

@@ExcellentDude I did exactly that and just got Fs and Es. BTW, I found a better solution, use the IFS function, it's just as good (and easier to use). Also, if in doubt use the function wizard, it's sometimes the formatting that causes the problems.

@cardboardmusic 8 ай бұрын

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

@ExcellentDude 8 ай бұрын

Sorry to hear that. Can you provide more details what is going wrong and maybe I can help get it working for you.

@cardboardmusic 8 ай бұрын

@@ExcellentDude Thanks for coming back so quickly. In the end I realised that using the IFS function worked just as well. BTW, I suspect that my problem was maybe using commas, instead of semi-colon.

@ExcellentDude 8 ай бұрын

OK - glad to hear you have a working solution. Cheers!