[問題] excel 條件判斷 去相減
(若是和其他不同軟體互動之問題 請記得一併填寫)
軟體:excel
版本:2010
範例如下
目前結果的算法是當判斷從A跳到B，要執行如下舉例的算法
數字 判斷(分成A與B兩種) 結果
5 A
8 A
6 B (6-5)/5=0.2
4 A (4-6)/6=-0.33
3 A
7 A
10 B (10-4)/4=1.5
大概算法是這樣，一遇到判斷變了才旭曜執行結果的值
因為目前資料滿大的，想說有簡易的語法可以去執行這功能嗎
謝謝
不好意思 再多弄一個條件
當數字大於條件 =>是A =>結果是(數字後面-數字前面)/數字前面
當數字小於條件 =>是B =>結果是(數字前面-數字後面)/數字前面
範例如下
數字 條件 判斷(分成A與B兩種) 結果
5 3 A
8 4 A
6 10 B (6-5)/5=0.2
4 2 A (6-4)/6=0.33
3 1 A
7 6 A
1 11 B (1-4)/4=-0.75
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 61.231.62.53
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1472989837.A.B3E.html
→
09/04 20:35, , 1F
09/04 20:35, 1F
※ 編輯: Jerome0511 (61.231.62.53), 09/04/2016 22:43:18
→
09/04 22:44, , 2F
09/04 22:44, 2F
推
09/04 22:48, , 3F
09/04 22:48, 3F
推
09/04 22:54, , 4F
09/04 22:54, 4F
→
09/05 00:00, , 5F
09/05 00:00, 5F
→
09/05 00:04, , 6F
09/05 00:04, 6F
→
09/05 00:05, , 7F
09/05 00:05, 7F
→
09/05 00:05, , 8F
09/05 00:05, 8F
推
09/05 00:05, , 9F
09/05 00:05, 9F
→
09/05 00:11, , 10F
09/05 00:11, 10F
→
09/05 00:15, , 11F
09/05 00:15, 11F
→
09/05 00:15, , 12F
09/05 00:15, 12F
→
09/05 00:16, , 13F
09/05 00:16, 13F
→
09/05 00:20, , 14F
09/05 00:20, 14F
→
09/05 10:00, , 15F
09/05 10:00, 15F
→
09/05 10:01, , 16F
09/05 10:01, 16F
→
09/05 10:28, , 17F
09/05 10:28, 17F
→
09/05 10:29, , 18F
09/05 10:29, 18F
推
09/05 10:51, , 19F
09/05 10:51, 19F
→
09/05 10:51, , 20F
09/05 10:51, 20F
→
09/05 10:52, , 21F
09/05 10:52, 21F
→
09/05 10:53, , 22F
09/05 10:53, 22F
→
09/05 10:53, , 23F
09/05 10:53, 23F
→
09/05 10:53, , 24F
09/05 10:53, 24F
→
09/05 10:54, , 25F
09/05 10:54, 25F
→
09/05 10:54, , 26F
09/05 10:54, 26F
→
09/05 11:17, , 27F
09/05 11:17, 27F
推
09/05 11:19, , 28F
09/05 11:19, 28F
→
09/05 11:39, , 29F
09/05 11:39, 29F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
