[算表] 若A則B多條件
軟體: office Excel
版本: 2016
問題:
若 欄位(ex.B2-A2) 差值為正值 則回傳數值為+1
為負值 則回傳數值為-1
為 0 則回傳數值為0
試了一天只會寫單一條件,無法在單一欄位寫入3種條件~
嘗試用if or 但是一直回傳錯誤,
請各位指點... 謝謝
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 211.75.255.98
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1460340962.A.CEC.html
→
04/11 10:19, , 1F
04/11 10:19, 1F
![](https://i.imgur.com/8txmvA3.jpg)
→
04/11 10:38, , 2F
04/11 10:38, 2F
![](https://i.imgur.com/WgxdvAb.jpg)
→
04/14 14:42, , 3F
04/14 14:42, 3F
→
04/14 16:21, , 4F
04/14 16:21, 4F
→
04/14 16:35, , 5F
04/14 16:35, 5F
![](https://i.imgur.com/b49s7V6.jpg)
→
04/14 16:37, , 6F
04/14 16:37, 6F
→
04/14 16:37, , 7F
04/14 16:37, 7F
推
04/15 17:13, , 8F
04/15 17:13, 8F
→
04/15 18:38, , 9F
04/15 18:38, 9F
→
04/15 18:40, , 10F
04/15 18:40, 10F
→
04/15 18:41, , 11F
04/15 18:41, 11F