Excel Magic Trick

Download Excel Start File: people.highlin...
Download Excel Finished File: people.highlin...
Full Page With All File Links: people.highline...
Use the SUM, VLOOKUP and ROUND functions to create a Grade Book Based on Percentage Scores that will calculate grade for you automatically. See how the VLOOKUP and the Percentage format can deliver the wrong Grade when you dont use the Round Function.
VLOOKUP function information.
ROUND function
Formulas for Grades.
Excel Lookup Series

[@nicoleb9277]

Only person to explain that the scores need to be in ascending order... much appreciated!

[@excelisfun]

You are welcome! I am glad that they are useful.

[@DrJuice1]

thank you so, so much! i have a meeting with my boss tomorrow, and being able to show how this works/what it can do will help me a ton!

[@excelisfun]

EXCELlent work on your test!!

[@katepryse-lloyd8218]

I've been meaning to learn how to do these lookups in excels for years, very simple, thankyou!

[@andreatantillo9636]

Game Changer. Thank you!

[@excelisfun]

You are welcome!!!

[@pouyan74]

Hello from 2022, and thanks!

[@excelisfun]

You are welcome! 2009 or 2022, this grading trick works like a charm : )

[@NabilahOthman]

i love the error. so we have possibilities.

[@excelisfun]

You are welcome!

[@forsteaua]

thanks to you i did really well in my test today, we have an awful teacher...you should be one:)

[@excelisfun]

I am using Camtasia. It is great!

[@forsteaua]

1025 videos:)) uber awesome man. Congratulations, very handy tutorial.
Thanks

[@labreeb3333]

This video was extremely helpful! It now makes sense to me!

[@46monkeyes]

Confused the heck out of me.

[@UmarYusuf]

How do I use database to manage a case of fail/repeat course in CGPA calculation.

[@roxipups6317]

This is very helpful tnx😊😊😊😊

[@shubahambanthiya4548]

thank you very much.......

[@kellyoku]

Thank you so much.

[@Stubborn67]

Thank you so much for this.

[@haileysss]

thank you

[@minajosie]

Very useful, like to download on Mac

[@queen_nathan8685]

Is it ok,if not using percent symbol??

[@paytonhanline8101]

How would you sort this spreadsheet by letter grade?

[@gabrielm3209]

whoever max is has a hella good score

[@roneybros5929]

Thank you! Might consider a pop filter when recording your voice. My ears were poppin lol.

[@humbertosoto6147]

F4 option to lock cell works on a mac?

[@uncle0eric]

+Humbe Soto COMMAND+t

[@edwinjons4697]

Sactacrack is a professional in his field much respect sir💯💯..

[@danieljohny5626]

hi
can any body help...i need to get an equation for this grading system..in a complete form...
A+ 90-100 %
A 85-89 %
A- 80-84 %
B+ 75-79 %
B 70-74 %
B- 65-69 %
C+ 60-64 %
C 55-59 %
C- 50-54 %
D 45-49 %
E 40-44 %
if i get 43 marks excel should display my grade as "E"....anybody can help me...?

[@excelisfun]

You are welcome!

[@edwinjons4697]

Sactacrack is a professional in his field much respect sir💯💯..