正在加载视频...
视频加载失败
STOP grading students' scores in Microsoft Excel like this:
84,742 次观看 • 2 年前 •via X (Twitter)
7 条评论

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

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

Crystal2 年前
Wow! Thank you Sir

Adrian2 年前
you will do it much faster function (if)

Joey Bellerose2 年前
Love the custom formatting. A very underused feature.

Danny Dann2 年前
Thank you @Eyowhite3 , it worked well

akindele baliqis2 年前
😲😲😲😲😲 This is so good 💯

