計算Excel 問題
2009-08-26 8:15 am
A
B
C
D
1
Name
Quantity
Price
Total
2
A newspaper
10 pieces
$6.00
3
B newspaper
20 pieces
$8.00
4
C newspaper
40 pieces
$10.00
Total
如何計算出來？
回答 (2)
2009-08-26 9:35 pm
✔ 最佳答案
這條題目, 最難的部份就是 數字後面有 單位, 如 10 pieces.解決方法是用 substitute( ) 函數 去 清除 單位, 例如 CELL D2 用
= substitute(b1, "pieces", "") * c2
就可以計算出 d2 應有的 $60 了.
將這個公式 copy 到下面2 格就可以了.
2009-08-26 8:24 am
Firstly, please do not enter "words" in the cell that used for calculation, please change cell B2, B3 and B4 to 10, 20 and 40
then type the formula in cell D2, D3 and D4 as follows:
D2: =b2*c2
D3: =b3*c3
D4: =b4*c4
for D5,
=sum(d2:d4)
then type the formula in cell D2, D3 and D4 as follows:
D2: =b2*c2
D3: =b3*c3
D4: =b4*c4
for D5,
=sum(d2:d4)
參考: ME
收錄日期: 2021-04-13 16:48:31
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20090826000051KK00043