Excel Tips: 用實例說明邏輯函數, IF() | AND() | OR() | Nested IF

[@kelvinchungsb]

咁多KZbinR 你最實用，獲益良多

[@KKLeung]

多謝收看

[@KenWonGz]

支持下先 😉

[@KKLeung]

多謝收看😀

[@rmok4258]

Leung Sir, this is the most detailed explanations I have ever seen, thanks. The way you have shown each function with arguments then result, which is true or false, further let us understand the important of the logic behind it.

[@KKLeung]

Thanks for your good comment 👍

[@rmok4258]

@@KKLeung I hope that you have a enjoyable three days off. I am still learning from your Pivot table series. Thanks

[@kelvinchungsb]

同時最近我有個問題，當我用POWER QUREY 做好晒個WORKSHEET想OUTPUT CSV 上銀行做AUTOPAY，但當中銀行卡號怎搞也搞不到，只出 "6.21723E＋18" ，有沒辨法幫忙幫忙

[@KKLeung]

Hi Kelvin, 你試吓在query 加一步，將卡號column 改變為text (文字）， 睇吓可否解決依個問題.. KK

[@mysoniasze]

請問用power query 做完的worksheet, format 係唔係一定要跟source worksheet一樣, 不能將字體加粗或者highlight

[@KKLeung]

Format 是不會跟source working sheet 一樣，power query 出會嘅資料你可自訂文字格式

[@mysoniasze]

謝謝回覆