[算表] 有辦法這樣算出空白值嗎??
軟體:excel
版本:2003
A B C
1 EEE EEE
2 EEE EEE
3 EEE EEE
4 CCC CCC
5 CCC CCC
6 GGG GGG GGG
7 空白
8 空白
9 空白
我寫了一個函數IF(A1="",B1,IF(B1="",A1,IF(A1=B1,A1)))
請問有什麼辦法當函數往下拉到C9時可以再A與B欄都無資料的情況下帶出空白值
如上表所表示,想了久用不出來,都會跑出0,有辦法嗎?? 感謝~@@
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 59.115.2.126
推
03/17 22:55, , 1F
03/17 22:55, 1F
→
03/17 23:04, , 2F
03/17 23:04, 2F
→
03/17 23:05, , 3F
03/17 23:05, 3F
→
03/17 23:07, , 4F
03/17 23:07, 4F
推
03/17 23:16, , 5F
03/17 23:16, 5F
推
03/17 23:35, , 6F
03/17 23:35, 6F
推
03/18 00:18, , 7F
03/18 00:18, 7F
推
03/18 00:32, , 8F
03/18 00:32, 8F
推
03/18 00:35, , 9F
03/18 00:35, 9F
→
03/18 00:42, , 10F
03/18 00:42, 10F
→
03/18 11:35, , 11F
03/18 11:35, 11F
→
03/18 14:38, , 12F
03/18 14:38, 12F