Excel 計減數如何寫算式?

2008-07-14 6:25 am
Excel 計減數如何寫算式?
如:income-outgoing=balance

回答 (2)

2008-07-14 7:51 am
✔ 最佳答案
Please try following examples:-

In cell A1, input "income"
In cell B1, input "outgoing"
In cell C1, input "balance"

In cell A2, input amount (eg. 1000) for income
In cell B2, input amount (eg. 200) for outgoing
In cell C2, input below formula:-

= A2 - B2

Then press enter, it will calculate and show result 800

Hope can solve your problem
2008-07-16 6:39 am
如income是100,outgoing是50,只要在cell內輸入:
=100-50,再按enter鍵己可以得到答案150。


收錄日期: 2021-04-13 16:29:21
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20080713000051KK02942

檢視 Wayback Machine 備份