想問問各位Excel老師，=IF(OR(A1="AA",A1="BB",A1="CC"),L36*L34,L36*L32)條式寫完如果A1係""的話都會有個"0"，如果要隱藏個"0"即是Blank，後面應該如何寫？多謝！?
回答 (1)
2018-10-10 4:23 pm
=IF(A1="","",IF(OR(A1="AA",A1="BB",A1="CC"),L34,L32)*L36)
收錄日期: 2021-04-24 10:52:44
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20181009121318AAv1OB9