[算表] EXCEL算式問題
軟體:excel
版本:2010
A B
A1 B1
A2 B2
B3
如果A2=0 則 B3=0 否則 B3=A1-A2 且B1,B2=0
我算式在B3是 if(A2=0,0,A1-A2) 但B1,B2要=0就接不下去了
請問要如何寫下去?
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 220.133.0.131
→
01/16 16:27, , 1F
01/16 16:27, 1F
→
01/16 16:28, , 2F
01/16 16:28, 2F
→
01/16 16:42, , 3F
01/16 16:42, 3F
→
01/16 16:43, , 4F
01/16 16:43, 4F
→
01/16 16:44, , 5F
01/16 16:44, 5F
→
01/16 16:47, , 6F
01/16 16:47, 6F
→
01/16 16:47, , 7F
01/16 16:47, 7F
→
01/16 16:59, , 8F
01/16 16:59, 8F
→
01/16 17:00, , 9F
01/16 17:00, 9F
→
01/16 17:15, , 10F
01/16 17:15, 10F
→
01/16 17:17, , 11F
01/16 17:17, 11F
→
01/16 17:35, , 12F
01/16 17:35, 12F
→
01/16 17:36, , 13F
01/16 17:36, 13F
→
01/16 17:47, , 14F
01/16 17:47, 14F
→
01/16 17:47, , 15F
01/16 17:47, 15F
→
01/16 17:50, , 16F
01/16 17:50, 16F
→
01/16 17:51, , 17F
01/16 17:51, 17F
→
01/16 18:03, , 18F
01/16 18:03, 18F
→
01/16 18:29, , 19F
01/16 18:29, 19F