提成區段平均數加基本额 (9001)

F3=IF(E3<=96,6000,IF(E3>140,10000,INDEX((E3-VLOOKUP(E3,B:B,1,1))*(C$4:C$5-C$3:C$4)/(B$4:B$5-B$3:B$4)+VLOOKUP(E3,B$3:C$5,2,1),1+(E3>=B$4))))

G3=IF(E3<=96,6000,IF(E3>140,10000,TREND(OFFSET(C$1,MATCH(E3,B:B)-1,,2),OFFSET(B$1,MATCH(E3,B:B)-1,,2),E3)))