[算表] Excel 判斷數值存在
手機發文,請多包涵
例如 :
a2:c2 隨機欄位內有數字1,
d2:f2 隨機欄位內有數字1,
g2:i2 隨機欄位內有數字1;
我應該如何下IF判斷式,例如搜尋到a2:c2有數字1,那我就給它ㄧ個指定值,搜尋到d2:f2有數字1,那我ㄧ樣給指定值,搜尋到g2:i2有數字1,給指定值這樣。。
-----
Sent from JPTT on my HTC One SV.
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 60.249.143.208
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1443067152.A.0D3.html
→
09/24 12:28, , 1F
09/24 12:28, 1F
→
09/24 12:48, , 2F
09/24 12:48, 2F
→
09/24 13:12, , 3F
09/24 13:12, 3F
→
09/24 13:12, , 4F
09/24 13:12, 4F
→
09/24 13:41, , 5F
09/24 13:41, 5F
→
09/24 13:42, , 6F
09/24 13:42, 6F
→
09/24 13:44, , 7F
09/24 13:44, 7F
→
09/24 13:45, , 8F
09/24 13:45, 8F