你这个和个人税计算差不多,最简单的是用if()函数:
A5收入实际根数,B5用if()做奖金计算:=IF(A5=70,0,IF(A5=100,(A5-70)*5,IF(A5=130,150(A5-100)*10,IF(A5=160,150300(A5-130)*15,IF(A5=190,150300450(A5-160)*20,IF(A5=220,150300450600(A5-190)*25,150300450600750(A5-220)*30))))))
C5计算平均奖金=if(A5=0,0,B5/A5)
|