[算表] EXCEL 公式如何變化
軟體:EXCEL
版本:97-2003
A B C D A B C
1 100 0 0 1 100 =B1-B$1 =SUM(C$1:C1)
2 99 -1 -1 2 99 =B2-B$1 =SUM(C$1:C2)
3 95 -5 -6 3 95 =B3-B$1 =SUM(C$1:C3)
4 99 -1 -7 4 99 =B4-B$1 =SUM(C$1:C4)
5 106 6 -1 5 106 =B5-B$1 =SUM(C$1:C5)
6 110 10 9 <------ 6 110 =B6-B$1 =SUM(C$1:C6)
7 113 3 3 7 113 =B7-B$6 =SUM(C$7:C7)
8 114 4 7 8 114 =B8-B$6 =SUM(C$7:C8)
9 109 -1 6 9 109 =B9-B$6 =SUM(C$7:C9)
10 105 -5 1 10 105 =B10-B$6=SUM(C$7:C10)
11 106 -4 -3 <--- 11 106 =B11-B$6=SUM(C$7:C11)
12 104 -2 -2 12 104 =B12-B$11SUM(C$12:C12)
13 103 -3 -5 13 103 =B13-B$11SUM(C$12:C13)
14 99 -7 -12 14 99 =B14-B$11SUM(C$12:C14)
15 105 -1 -13 15 105 =B15-B$11SUM(C$12:C15)
當C6出現正值時,B行及C行的公式變成如上,
當C11變成負值時,B行及C行的公式變成如上,
B行C行公式要如何寫?
如果不要用太難或不要用陣列的公式,多幾行沒關係
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 60.248.19.151
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1431582129.A.1BB.html
※ 編輯: jie123 (60.248.19.151), 05/14/2015 13:48:11
→
05/14 15:33, , 1F
05/14 15:33, 1F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
