請問在excel 如何設定 formula :
e.g.
A1 = L or S
B1 = 10000 (when A1 = S) or 9888 (when A1 = L)
C1 = S (when A1 = L) or L (when A1=S)
D1 = 9888 or 10000
E : formula needed (if A1=S, then B1-D1; and if A1=L, then D1-B1)
thanks.
excel formula 一問
2010-06-10 4:09 am
回答 (2)
2010-06-18 10:29 pm
✔ 最佳答案
E: =IF(A1="S", B1-D1,IF(A1="L",D1-B1))
2010-06-10 3:19 pm
B1=IF(A1="S",10000,9888)
C1=IF(A1="L","S","L")
E1=IF(A1="S",B1-D1,D1-B1)
2010-06-10 07:23:20 補充：
B1=IF(A1="","",IF(A1="S",10000,9888))
C1=IF(A1="","",IF(A1="L","S","L"))
E1=IF(A1="","",IF(A1="S",B1-D1,D1-B1))
C1=IF(A1="L","S","L")
E1=IF(A1="S",B1-D1,D1-B1)
2010-06-10 07:23:20 補充：
B1=IF(A1="","",IF(A1="S",10000,9888))
C1=IF(A1="","",IF(A1="L","S","L"))
E1=IF(A1="","",IF(A1="S",B1-D1,D1-B1))
收錄日期: 2021-04-23 23:31:15
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20100609000051KK01261