用excel计算提成的公式?答:B4单元格公式=IF(AND(B2+B3>16,B2>8,B3>8),(B2-8)*5+(B3-8)*3,IF(AND(B2+B3>16,B2>8,B3<8),(B2-8+B3-8)*5,IF(AND(B2+B3>16,B2<8,B3>8),(B3-8+B2-8)*3,"")))右拉公式。如图:
excel业绩提成计算公式答:假定业绩在A1单元格,在B1单元格计算提成,则在B1写公式:=LOOKUP(A1,{0,10001,20001,30001,50001,100001,150001},{0.45,0.48,0.5,0.52,0.55,0.58,0.65})*A1-LOOKUP(A1,{0,10001,20001,30001,50001,100001,150001},{0,0,0,600,2100,5100,15600})上面的公式实现:在1-30000以内的...