[算表] vlookup問題
軟體:office excel
版本:2010
Staff ID Profit Commission
NORD109190 136,319.00 ?
NORD141600 15,708.00 ?
NORD212308 22,321.00 ?
NORD213292 15,477.00 ?
NORD226279 27,321.00 ?
StaffID Salary point
NORD109190 Junior Salesperson
NORD114088 Mechanic
NORD141600 Department Manager
NORD212308 Executive Officer
NORD213292 Department Manager
NORD226279 Senior Salesperson
Position Percentage
JUNIOR SALESPERSONS 2%
SALESPERSONS 5%
SENIOR SALESPERSONS 7%
DEPARTMENT MANAGERS 10%
EXECUTIVE OFFICERS 8%
這有三章表 需要先從第二章表得知是哪個職位 得知職位後從第三表得之傭金的百分比
NORD109190 136,319.00*2%=2726 想過是不是可以用vlookup找兩次來找答案
但是好像沒辦法 請板上高人指點 謝謝!
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 203.219.65.37
※ 文章網址: http://www.ptt.cc/bbs/Office/M.1399894627.A.AD9.html
→
05/12 19:58, , 1F
05/12 19:58, 1F
→
05/12 19:58, , 2F
05/12 19:58, 2F
→
05/13 00:40, , 3F
05/13 00:40, 3F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
