[算表] 業績獎金級距
軟體:Office Excel
版本: 2010
不好意思，最近在做獎金分級的excel，但抓不到頭緒，只好上來請教。
舉例:
全月達成率
200%以上 $10000
150%-199% $9000
140%-149% $8000
130%-139% $7000
120%-129% $6000
110%-119% $5000
100%-109% $4000
90%- 99% $3000
80%- 89% $2000
70%- 79% $1000
0%- 69% $ 0
我爬文章是寫用VLOOKUP，但值就是跑不出來。
請問有比較簡單的解法嗎?
謝謝各位大大。
--
昂首千丘遠
嘯傲風間
堪尋敵手共論劍
高處不勝寒
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 223.139.54.120
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1458536567.A.EA3.html
→
03/21 13:15, , 1F
03/21 13:15, 1F
→
03/21 13:29, , 2F
03/21 13:29, 2F
→
03/21 13:30, , 3F
03/21 13:30, 3F
→
03/21 14:05, , 4F
03/21 14:05, 4F
→
03/21 14:05, , 5F
03/21 14:05, 5F
→
03/21 14:05, , 6F
03/21 14:05, 6F
→
03/21 14:05, , 7F
03/21 14:05, 7F
→
03/21 14:05, , 8F
03/21 14:05, 8F
→
03/21 14:08, , 9F
03/21 14:08, 9F
→
03/21 14:08, , 10F
03/21 14:08, 10F
→
03/21 14:11, , 11F
03/21 14:11, 11F
→
03/21 14:11, , 12F
03/21 14:11, 12F
→
03/21 14:11, , 13F
03/21 14:11, 13F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
