[算表]儲存格A若填上資料，B則滿足相關算式
軟體:excel2007
版本:
儲存格A無任何資料，為空白儲存格，
若填上任何形式的資料(數字文字時間...等)，則儲存格B為0
B=if(a="?",0)
請教?該填入什麼?
因為不知道怎麼下關鍵字，如曾有相同問題還請指教。
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 220.134.139.233
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1475717024.A.C37.html
→
10/06 09:27, , 1F
10/06 09:27, 1F
→
10/06 10:12, , 2F
10/06 10:12, 2F
→
10/06 10:16, , 3F
10/06 10:16, 3F
→
10/06 10:20, , 4F
10/06 10:20, 4F
→
10/06 13:30, , 5F
10/06 13:30, 5F
→
10/06 13:34, , 6F
10/06 13:34, 6F
→
10/06 13:37, , 7F
10/06 13:37, 7F
→
10/06 13:38, , 8F
10/06 13:38, 8F
→
10/06 13:39, , 9F
10/06 13:39, 9F
→
10/06 13:41, , 10F
10/06 13:41, 10F
→
10/06 13:42, , 11F
10/06 13:42, 11F
→
10/06 13:42, , 12F
10/06 13:42, 12F
→
10/06 13:45, , 13F
10/06 13:45, 13F
→
10/06 13:45, , 14F
10/06 13:45, 14F
→
10/06 14:06, , 15F
10/06 14:06, 15F
→
10/06 14:07, , 16F
10/06 14:07, 16F
→
10/06 14:07, , 17F
10/06 14:07, 17F
→
10/06 14:08, , 18F
10/06 14:08, 18F
→
10/06 14:22, , 19F
10/06 14:22, 19F
→
10/06 14:24, , 20F
10/06 14:24, 20F
→
10/06 14:37, , 21F
10/06 14:37, 21F
→
10/06 14:37, , 22F
10/06 14:37, 22F
→
10/06 14:38, , 23F
10/06 14:38, 23F
→
10/06 14:38, , 24F
10/06 14:38, 24F
感謝大家熱情相助，是我沒把問題問好
A1若為空白儲存格，則B1=C1
A1若填入任何形式的資料，則B1=0
所以
B1=if(a1="",b1=c1,0)就可以解決了
早上腦袋轉不過來一直陷在"任何形式的資料"
對不起大家
※ 編輯: organic (220.134.139.233), 10/06/2016 16:35:45
Office 近期熱門文章
PTT數位生活區 即時熱門文章