[算表] EXCEL 公式如何变化

楼主: jie123 (jie123)   2015-05-14 13:42:06
软件: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 <
作者: soyoso (我是耀宗)   2015-05-14 15:33:00

Links booklink

Contact Us: admin [ a t ] ucptt.com