excel formula

2012-11-11 7:49 am
本金減本金的5%再減本金的10% 的excel formula 點set

回答 (4)

2012-11-12 5:34 am
✔ 最佳答案
假設 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)
2012-11-13 3:34 am
A1=100, B1=5%, C1=10%
D1 輸入 =A1*(1-B1-C1)
2012-11-11 6:55 pm
是那一樣?

A:
100-5% = 95
95-10% = 85.5

OR

B:
100-5%-10% =85
2012-11-11 9:37 am
假設本金放係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 備份