excel formula
本金減本金的5%再減本金的10% 的excel formula 點set
回答 (4)
✔ 最佳答案
假設 A1=100, B1=5%, C1=10%
B1 輸入 =A1*(1-B1-C1)
2012-11-11 21:43:08 補充:
更正:
第二行之 "B1" 應更正為 "D1", 抱歉!
2012-11-11 21:55:35 補充:
即是 "D1" 輸入 =A1*(1-B1-C1)
A1=100, B1=5%, C1=10%
D1 輸入 =A1*(1-B1-C1)
是那一樣?
A:
100-5% = 95
95-10% = 85.5
OR
B:
100-5%-10% =85
假設本金放係A1格
=A1-A1*0.05-A1*0.9
收錄日期: 2021-04-13 19:06:02
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20121110000051KK00633
檢視 Wayback Machine 備份