[算表] IF判斷
請問板上的大大excel
A
1 Z1XXXX
2 Z2XXXX
3 Z3XXXX
4 Z4XXXX
5 Z1XXXX
6 ZAXXXX
想判斷A欄值左邊兩位為Z1或Z2,欄B顯示為a,其餘為b
原本想說可以=IF(A1={"Z1","Z2"},"a","b"}結果不行,想請教該怎麼寫才好。
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 111.70.76.22
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1467815975.A.DB1.html
推
07/06 22:54, , 1F
07/06 22:54, 1F
→
07/06 22:56, , 2F
07/06 22:56, 2F
→
07/06 23:02, , 3F
07/06 23:02, 3F
→
07/06 23:02, , 4F
07/06 23:02, 4F
→
07/07 06:24, , 5F
07/07 06:24, 5F
推
07/08 10:32, , 6F
07/08 10:32, 6F