Excel Magic Trick
HTML-код
- Опубликовано: 11 сен 2024
- 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
Only person to explain that the scores need to be in ascending order... much appreciated!
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!
I've been meaning to learn how to do these lookups in excels for years, very simple, thankyou!
You are welcome! I am glad that they are useful.
Hello from 2022, and thanks!
You are welcome! 2009 or 2022, this grading trick works like a charm : )
Game Changer. Thank you!
You are welcome!!!
EXCELlent work on your test!!
i love the error. so we have possibilities.
You are welcome!
I am using Camtasia. It is great!
thanks to you i did really well in my test today, we have an awful teacher...you should be one:)
This video was extremely helpful! It now makes sense to me!
1025 videos:)) uber awesome man. Congratulations, very handy tutorial.
Thanks
Thank you so much.
Confused the heck out of me.
thank you
thank you very much.......
How do I use database to manage a case of fail/repeat course in CGPA calculation.
Thank you so much for this.
This is very helpful tnx😊😊😊😊
Is it ok,if not using percent symbol??
Very useful, like to download on Mac
How would you sort this spreadsheet by letter grade?
Thank you! Might consider a pop filter when recording your voice. My ears were poppin lol.
F4 option to lock cell works on a mac?
+Humbe Soto COMMAND+t
whoever max is has a hella good score
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...?
Sactacrack is a professional in his field much respect sir💯💯..
You are welcome!
Sactacrack is a professional in his field much respect sir💯💯..