Loading video...

Video Failed to Load

Go Home

STOP grading students' scores in Microsoft Excel like this:

84,742 views • 2 years ago •via X (Twitter)

7 Comments

Sulaimon Wasiu's profile picture
Sulaimon Wasiu2 years ago

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

Shahed Chowdhuri's profile picture
Shahed Chowdhuri2 years ago

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

Crystal's profile picture
Crystal2 years ago

Wow! Thank you Sir

Adrian's profile picture
Adrian2 years ago

you will do it much faster function (if)

Joey Bellerose's profile picture
Joey Bellerose2 years ago

Love the custom formatting. A very underused feature.

Danny Dann's profile picture
Danny Dann2 years ago

Thank you @Eyowhite3 , it worked well

akindele baliqis's profile picture
akindele baliqis2 years ago

😲😲😲😲😲 This is so good 💯

Related Videos