2006-11-16 18:26:02稚气滴惡魔
EXCEL_306
1.=VLOOKUP(MID($A3,3,3),單位,2,0)
=VLOOKUP(MID($A3,7,1),組別,2,0)
=VLOOKUP(VALUE(MID($A3,1,1)),升等,2,0)
2.(1)=AVERAGE(VLOOKUP(F3,考績等級,2,0),VLOOKUP(G3,考績等級,2,0),VLOOKUP(H3,考評等級,2,0))
(2)=I3*30%+J3*70%
3.=ROUND(K3*0.6+L3*0.4,1)
4.=RANK(M3,$M$3:$M$40)
=VLOOKUP(MID($A3,7,1),組別,2,0)
=VLOOKUP(VALUE(MID($A3,1,1)),升等,2,0)
2.(1)=AVERAGE(VLOOKUP(F3,考績等級,2,0),VLOOKUP(G3,考績等級,2,0),VLOOKUP(H3,考評等級,2,0))
(2)=I3*30%+J3*70%
3.=ROUND(K3*0.6+L3*0.4,1)
4.=RANK(M3,$M$3:$M$40)