條件1:A4<=12 and B4<=8
條件2:A4<=15 and B4<=3
條件3:A4=16 and B4<=2
條件4:A4=17 and B4=0
4個條件 true 出ok , false出 replace
求Formula完成上述條件
收錄日期: 2021-04-13 19:41:43
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20130830000051KK00050