[算表] 循環輸入

看板Office作者archknight (布丁牛奶)時間13年前 (2012/09/29 02:20)推噓0(0推 0噓 9→)

留言9則, 3人參與討論串1/1

軟體:Excel 版本:2010 請問我有公式如下： =IF($C$5=1,$C$4,0) =IF($C$8=1,$C$7,0) =IF($C$11=1,$C$10,0) =IF($C$14=1,$C$13,0) =IF($C$17=1,$C$16,0) =IF($C$20=1,$C$19,0) =IF($C$24=1,$C$23,0) =IF($C$27=1,$C$26,0) =IF($C$30=1,$C$29,0) =IF($C$33=1,$C$32,0) =IF($C$36=1,$C$35,0) =IF($C$39=1,$C$38,0) 要如何只把英文的C一直累加到Z呢？ -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 124.11.244.79

→

Rplus

09/29 15:05, , 1^F

09/29 15:05, 1^F

→

newacc

09/29 19:00, , 2^F

09/29 19:00, 2^F

→

archknight

09/30 01:02, , 3^F

09/30 01:02, 3^F