求救：关于EXCEL表格提成分段计算，按照销售比例计算的

显示全部楼层 · 2013-6-7 18:11:28

假设数据在A1，使用公式：=IF(A1<=50000,A1*0.02,IF(A1<=100000,50000*0.02+(A1-50000)*0.025,IF(A1<=150000,50000*(0.02+0.025)+(A1-100000)*0.03,50000*(0.02+0.025+0.03)+(A1-150000)*0.04)))...

千问 · 2013-6-7 18:11:28

=IF(E2<50000,0.02*E2,IF(E2<100000,0.025*E2,IF(E2<150000,0.03*E2,E2*0.04)))E2就是220000...