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!

[@pouyan74]

Hello from 2022, and thanks!

[@excelisfun]

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

[@andreatantillo9636]

Game Changer. Thank you!

[@excelisfun]

You are welcome!!!

[@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!

[@katepryse-lloyd8218]

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

[@NabilahOthman]

i love the error. so we have possibilities.

[@excelisfun]

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

[@excelisfun]

EXCELlent work on your test!!

[@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!

[@excelisfun]

You are welcome!

[@forsteaua]

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

[@labreeb3333]

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

[@shubahambanthiya4548]

thank you very much.......

[@kellyoku]

Thank you so much.

[@haileysss]

thank you

[@roxipups6317]

This is very helpful tnx😊😊😊😊

[@UmarYusuf]

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

[@Stubborn67]

Thank you so much for this.

[@46monkeyes]

Confused the heck out of me.

[@minajosie]

Very useful, like to download on Mac

[@roneybros]

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

[@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

[@edwinjons4697]

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

[@humbertosoto6147]

F4 option to lock cell works on a mac?

[@uncle0eric]

+Humbe Soto COMMAND+t

[@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💯💯..