[算表] excel 合併儲存格的加法問題...
軟體:excel
版本:2010
如果有人問過了..真的很抱歉..文很難爬...
A B C(=A+B)
1 4 7(A1+B1)
2 3 5 8
3 6 9
4 7 10
//對A來說 1.2.3.4合併成一個儲存格
以上是我希望的加法..可是我的excel都會變成這樣
A B C(=A+B)
1 4 7(A1+B1)
2 3 5 5
3 6 6
4 7 7
就是在C2之後的運算那邊 excel在A2,A3,A4會判斷成0
...QQ
希望有大大可以幫忙解答一下
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.113.63.16
※ 編輯: kiloxx 來自: 140.113.63.16 (10/29 21:36)
→
10/29 21:45, , 1F
10/29 21:45, 1F
→
10/29 21:47, , 2F
10/29 21:47, 2F
→
10/29 21:48, , 3F
10/29 21:48, 3F
推
10/29 21:49, , 4F
10/29 21:49, 4F
→
10/29 21:51, , 5F
10/29 21:51, 5F
→
10/29 21:52, , 6F
10/29 21:52, 6F
→
10/29 21:54, , 7F
10/29 21:54, 7F
→
10/29 21:57, , 8F
10/29 21:57, 8F
→
10/29 21:58, , 9F
10/29 21:58, 9F
→
10/29 21:59, , 10F
10/29 21:59, 10F
→
10/29 21:59, , 11F
10/29 21:59, 11F
→
10/29 22:00, , 12F
10/29 22:00, 12F
→
10/29 22:02, , 13F
10/29 22:02, 13F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
