我想寫一條formula, e.g. =A1/B1
但我想要A1 and B1都有data時才出現結果, 條formula應如何寫?
thanks a lot!!
Excel Formula
2007-07-11 11:35 pm
回答 (3)
2007-07-13 3:44 pm
✔ 最佳答案
=IF(OR(A1= "",B1= ""), "", A1/B1)如果真係用A1/B1，建議加B1>0，以避免除零
=IF(OR(A1= "",B1= "",B1=0), "", A1/B1)
參考: 個人經驗
2007-07-12 1:59 am
2007-07-12 1:59 am
=IF(AND(ISNUMBER(A2),ISNUMBER(B2)),A2/B2,"")
hope can help u, maybe not the best way to do
2007-07-11 18:00:17 補充：
=IF(AND(ISNUMBER(A2),ISNUMBER(B2)),A2/B2,"")
2007-07-11 18:01:20 補充：
冇 ; HTML 有 bug
hope can help u, maybe not the best way to do
2007-07-11 18:00:17 補充：
=IF(AND(ISNUMBER(A2),ISNUMBER(B2)),A2/B2,"")
2007-07-11 18:01:20 補充：
冇 ; HTML 有 bug
收錄日期: 2021-04-18 22:41:58
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20070711000051KK02429