How to Assign Letter Grades in Excel

Join 400,000+ professionals in our courses: www.xelplus.com/courses/
Calculating and assigning letter grades to students based on their achieved score is a common task. I'll show you how a super simple solution in Microsoft Excel to automate this task. Forget the Excel IF function for this. Instead use Excel VLOOKUP function. If you have office 365, you can use the XLOOKUP function as well.
🎬 LINK to more KZbin Shorts videos: • Shorts (Tips, Tricks &...
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
📚 Excel RESOURCES I Recommend: www.xelplus.com/resources/
🎥 GEAR I use: www.xelplus.com/resources/#gear
More resources on my Amazon page: www.amazon.com/shop/leilagharani
🚩Let’s connect on social:
Instagram: / lgharani
Twitter: / leilagharani
LinkedIn: / leilagharani
👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel

[@dbaker280]

The key here is non-exact matching in the VLOOKUP. Notice she didn’t include the last argument so it defaulted to true. This allows non-exact matching which assumes the lookup column is sorted in ascending order and matches the first row where the lookup value is greater.

[@galvem01]

Thanks for explaining it!

[@menggay8215]

Very helpful

[@BulshoSomali]

Agree I can't see FALSE OR 0 ( in accounting you need no be 100% true )

[@Griffiths1]

I thought the default was false for this? Or am I mistaken, I’ve never not written it actually, just thinking about it.

[@mariaw7746]

Using it

[@mohammadtoolbar]

OMG all my life I have been using IF functions, which takes a while to set. Wish I knew this method from before. Leila you are a life saver!!!!

[@Nindzsaaa]

I appreciate these small examples but that 55 buggling me hard. ;)

[@noctusowl]

Some sort of multiple choice that would increase the oddsof scoring something even if you don't know nothing. Just did a test with 67% pass grade because of this.

[@eduardosanchez2558]

Totally

[@vinz2316]

I really appreciate this. Learned this on my own. Thank you for explaining it.

[@VisuLytics]

Very helpful...thanks for sparing time to make this video

[@alicjapasternak9550]

I live this tip!

[@AldoArellanoYcaza]

God bless you Leila!

[@abdulsamnan3539]

Mam you earned me as subscriber beautifully explained

[@vuhoang7109]

Excel with automation! Magic! Thanks Leila!🙂

[@abqnm8811]

I agree that one should avoid doing tasks manually whenever possible. Just a note on your method; for those that do not want the extra columns containing the grading criteria to show, hiding columns will not impact the function. Alternatively, this can be accomplished with a nested IF statement. =IF(I2>=0.905,"A",IF(I2>=0.805,"B",IF(I2>=0.705,"C",IF(I2>=0.605,"D",IF(I2

[@joanisloukio288]

She's amazing

[@SL-jn4em]

Good to know! Thanks a lot!

[@mmmazayyy]

These videos make me so excited

[@talkinghat88]

Great demo of xlooup thanks

[@jawadhussain8175]

Thank You. Learned 03 new things. F4, flash fill and the task itself

[@BlessedKomal]

Excellent Tip...Thank you

[@DvACtOid]

You could also try with switch, ifs and nested if

[@ranim4296]

Thanks for sharing!

[@pacific322]

I’m so glad to be subscribed to your channel.

[@sachinkishore4115]

Thanks a lot for this tips

[@tumbox9204]

Please send Sid Sloth to my office. That grade is outrageous.

[@Bejunckt]

He only got his name right on his test

[@nfortehbruno2993]

This is awesome,thanks!

[@johnramos1997]

This is awesome!

[@regal_7877]

Very informative thank you

[@myeyezee]

There is an error in your bins. Both F and D contain value of 55

[@Pranit.Gaikwad]

Yes typo error, but hope understood the scenario

[@123rockstar2010]

Student: Teacher, why did you gave me an F? Teacher: I was just following Leila’s Excel tips.

[@sahanpubudu4565]

Superb👍 thank you very much this video❤

[@dronepiratevisuals]

THANK YOU! Your tutorial just helped me solved a huge problem.

[@LeilaGharani]

Glad it helped!

[@reenamohanta2994]

Wow .. i didn't know ..🤯 will try .i am seriously loving this channel's youtube shorts ... so much to learn 💟

[@wifienergy6449]

Advance ms office excel, you’ll learn more.. Appreciate this one too👍

[@alfredyt]

This is is so easy if with if formula

[@firli82]

Thanks for the tip

[@brandonprice1992]

I needed this

[@safeerkooliyattayil7750]

Nice presentation

[@profha2]

That's helpful. Thx

[@IzziedeD]

spectacular!

[@shavezkhan786]

You're awesome ♥️

[@CourtWatchAu]

great lesson

[@JoshVamos]

Great use of vlookup

[@chinnavassi6537]

Superb❤❤❤😊

[@cftutorials]

Thank you.

[@Llb890]

I love you and the way teach

[@Buharialtinee]

Thanks for sharing

[@VM_Studiosblr]

This trick was very useful instead of if function

[@user-wf8fw4po7g]

Amazing ❤

[@DzBuZiness]

Thanks a lot

[@muchanic]

Of course Sheldon Cooper has A with score 99 Thanks for nice tip, it is great as always

[@gadgetvelly2023]

I follow your Every content. Also I will try. Thanks dear from Bangladesh.

[@riddhishah9574]

I knew vlookup but never knew this function. Thanks a lot

[@ld8151]

Thanks for the how to. It almost feels like you need to be a programmer to work excel.

[@aSpyIntheHaus]

You got a sub from me before. But this vid is gold!

[@alializadeh8195]

Thanx

[@ahmedsaleh2920]

Great! 🤩

[@zimcoder]

Now this was useful

[@Arya.gamer.7]

You can use =if(and( for the rank

[@ganyatsu]

Christopher Moltisanti 👌🏼👌🏼

[@LeilaGharani]

Loved the show!

[@petr6617]

Intervals: Text to Columns, and people should know the last (missing here) parameter of VLOOKUP function, which requires the proper ordering of the data and tells what value will be used in the case of an inaccurate match

[@TheAtypicalOne]

Thank you, super useful. I found it only worked if the grade table was sorted ascending. (First try the grades were high-to-low and it didn't work)

[@stevemoffat9480]

am also suprised you didnt use tables here rather than fixed refs, but love your stuff

[@LesterSuggs]

Amazing

[@Trucs_Et_Astuces]

Same with lookup let take colum of letters more freely

[@terry_the_terrible]

It works because she's using the Approximation option of the VLOOKUP formula which will assign a value if the number is higher than the lower bound of a category. Works only on numbers and only if the score is ordered from lowest to highest.

[@LeilaGharani]

True. If it's not ordered from lowest to highest, you can use XLOOKUP.

[@PremKumar-rf3mo]

Fantastic..

[@davejohn7781]

Wow!!! I used 'if' function for this, which is very confusing. This video shows a way more simple formula.

[@aigbeeromon1041]

Lovely

[@pauljoseph3081]

Ma'am, you got my grade wrong. I'm calling mom.

[@catatoa]

Thanks

[@LeilaGharani]

Many thanks!

[@djb6496]

Nice

[@salmanmehmood470]

Nice 🙂

[@akbarazizulhakim5702]

OOOOOOWWWWW THAAANKKKSSSSS

[@Sunsetcolors_sweetdreams]

Ease way to do with IF formula

[@batb6031]

Great

[@everenferno]

She did Kim West dirty

[@KhaledsWay]

The cover 😍

[@robertthomas5906]

Cool. Now set it up so it'll keep track of all the grades in a marking period and rank the students. One column should be the student number. Then the ranking can be posted in the classroom. We had a basic program to do this when I was in high school in the early 1980s. It ran on a HP2000.

[@LeilaGharani]

👍

[@nikarko01]

Uao! Ctlr+E and F4 is actually what I learned in this video 😂 U inow I lvoe these videos because even though you may know how to do these this u can still learn a way to make that faster or quicker indeed

[@sivareddy3745]

Super tric Laila it newly from you only.

[@magimus13]

These have been so helpful. I haven’t had a chance to watch them all is there one on how to make a spreadsheet that says moves a whole row up if say a column with a date is changed. So that the spreadsheet is sorted by the next date?

[@Matilda_the_Hun]

Get it together Sid

[@LeilaGharani]

😁

[@afakethrum]

Ctrl+E autofill is more exciting

[@raulbottle6483]

I´d use VBA

[@brothercannon]

F4 to fix referencing will change my life.

[@ahmedalkaseir7591]

I love you, i like your videos 💋💋

[@user-sf6so8ff4d]

Dear Leila, adore your videos and continue to study with them, would kindly ask how you would create a nice chart found in internet but can not add here that image(

[@brandonjustice5879]

Use array formula to fix the copy down.

[@vijaijoshua5683]

Good & simple demo nice, how to form if comments pls. Espicialy time chart.

[@ssstudent123]

Sheldon Cooper, Mike Delfino, Gabrielle Solis - are you a fan of Big bang theory and desperate housewives? Anyone noticed more TV series characters?

[@LeilaGharani]

Hint: Startrek, Sopranos, Seinfeld - the classics 😁

[@ssstudent123]

@@LeilaGharani nice, thanks for the hints ;) but with these series I’m not really familiar with. If it was up to me I would include legen… wait for it …dary - Barney Stinson, Harvey Specter, Oberyn Martell, Kelly Bundy and Tom „Iceman” Kazansky ;) All the best from Poland ! :)

[@christophermusso]

@ssstudent123 I saw some from Knight Rider, Golden Girls & Roseanne. Don Johnson also snuck in there.

[@jhonartcis8296]

thanks, i use a nested of on tha

[@HauntedHarpist]

I don't understand how come you don't have to state condition C is higher than G, and it still works?

[@exostel7033]

How did Sid mess up that bad 💀

[@kayo1265]

Wait... Doesn't vlookup look for exact match? How does vlookup work if the value isn't in column 1??

[@sleepywhentired6364]

Exactly! I am very curious to know how this works. It looks very useful but how does the function determine if I want lookup within a range or exact values?

[@imserge9559]

If you notice, she didn't include the last criteria in the vlookup which is the "True" or "False" that determines the lookup based on exact value or the approximate value. I don't remember which is which but i guess by default it is set to approximate.

[@Joseph20203]

@@imserge9559 makes sense

[@kayo1265]

@@imserge9559 @@imserge9559 been using vlookuo for over 18yrs and oddly never had to apply a result based on a range like grades in my profession but I'll try this out like in the example and see. Usually the last formula element is based on true/false, 1/0. If left blank I was thinking it would default to a #NA If no match. Again I'll check myself and test.

[@Sabrina-bm9qt]

So if someone gets a 55 do they get a D or an F? Should it be 0-54? Do they just randomly choose if they get that score?

[@nenadcimerman5178]

It'll be a D grade, because it's equal to the value in cell G3. The values in range F2:F6 are of type "text" and are not referenced in the vlookup-formula, so the don't matter to the result - only description for the user/teacher. However, you're right, that F2 should contain "0 - 54".

[@gurumano6733]

If there's a merged cells in score(F) then how you may solve this?🧐🧐🧐

[@pandimugunthan9656]

Use conditional format

[@matthewlawton541]

Sheldon coopers going to be pissed to find out he only got 99 out of 100

[@LeilaGharani]

No one gets a perfect score on my tests. Not even Sheldon! 😊

[@SEVENCRYPTOCHANNEL]

You can use if function. As well :D

[@shinzero7260]

What version excel you use? Does this work on all version?

[@akshaykotni7158]

We can use lookup function?

[@chh8860]

I don't think I have a need for this function (yet) ... but I am curious: isn't XLookUp also an option??? Thank you ... thank you ... thank you ... 😍

[@LeilaGharani]

Definitely! XLOOKUP and LOOKUP both will work. My personal preference is XLOOKUP because even if we mix the order of the boundaries, the function will still work, whereas VLOOKUP and LOOKUP will fail. I went with this solution because I've noticed many use the IF function for these cases and I know every Excel version has VLOOKUP 😀.

[@chh8860]

@@LeilaGharani 😍😍😍

[@overlordop6191]

How can I assign Gpa values instead of F C or D grades?