Loading video...
Video Failed to Load
STOP grading students' scores in Microsoft Excel like this:
84,742 views • 2 years ago •via X (Twitter)
7 Comments

Sulaimon Wasiu2 years ago
SELECT t.* , CASE WHEN t.marks >= 33 THEN 'pass' ELSE 'fail' END AS status FROM table AS t;

Shahed Chowdhuri2 years ago
Woah. I didn’t know you could use the format feature for that… thanks for sharing!

Crystal2 years ago
Wow! Thank you Sir

Adrian2 years ago
you will do it much faster function (if)

Joey Bellerose2 years ago
Love the custom formatting. A very underused feature.

Danny Dann2 years ago
Thank you @Eyowhite3 , it worked well

akindele baliqis2 years ago
😲😲😲😲😲 This is so good 💯

