=ROUND(MAX((T5-3500)*5%*{0.6,2,4,5,6,7,9}-5*{0,21,111,201,551,110...答:1.第一层函数:round(X,2)是一个四舍五入到小数点后两位的函数,2.第二层函数:MAX((a1-3500)*5%*{0.6,2,4,5,6,7,9}-5*{0,21,111,201,551,1101,2701},0),计算的数值是(a2-3500)后的值与相应税级百分数(0,0.03,0.1,0.2……)的乘积减去税率所在级距的速算扣除数0...
用round(if())函数求个人所得税为什么有的人会差一分钱?excel居然会算...答:这不荒唐,这是浮点小数运算存在的误差,可以在中间环节加ROUND函数保留小数位数。一般不用IF函数计算,可以用下面的公式:=ROUND(MAX((Q7-3500)*{0.03,0.1,0.2,0.25,0.3,0.35,0.45}-{0,105,555,1005,2755,5505,13505},0),2)如果认为没那么高,也可以将后面的去掉,用:=ROUND(MAX(...
如何用MAX函数计算个人所得税答:=ROUND(MAX((B13-D13-4800)*{0,0.05,0.1,0.15,0.2,0.25,0.3,0.35,0.4,0.45}-{0,0,25,125,375,1375,3375,6375,10375,15375}),2)
求:税后年终奖倒推税前金额的EXCEL函数公式答:公式=ROUND((C3-IF(C3<=34920,0,IF(C3<=129810,210,IF(C3<=241410,1410,IF(C3<=317660,2660,IF(C3<=466410,4410,IF(C3<=6631160,7160,15160)))/(1-IF(C3<=34920,3%,IF(C3<=129810,10%,IF(C3<=241410,20%,IF(C3<=317660,25%,IF(C3<=466410,30%,IF(C3<=631160,35%,45%))...
excel计算个人所得税的公式是什么?答:=5*MAX(K50*{0.6,2,4,5,6,7,9}% - {21,70,140,175,210,245,315} - {0,21,111,201,551,1101,2701}, 0)=5*MAX(K50*{0.6,2,4,5,6,7,9}% - {21,91,251,376,761,1346,3016} , 0)4、可以在外面套一个ROUND函数,四舍五入到2位小数,即:=ROUND(5*MAX(J50*{0...
Excel表格中怎么计算个人所得税答:如果应发工资在B2单元格,那么输入 =ROUND(MAX((B2-3500)*0.05*{0.6,2,4,5,6,7,9}-5*{0,21,111,201,551,1101,2701},0),2)
工资计算方法 用函数计算征税数额税计算方法答:(C2-3500)*0.1-105,(C2-3500)*0.03))),0),2)。公式中的*0.45等表示的是税率,应发工资小于等于3500元不收税。方法二,用函数公式通过查找取数的方法计算税额,输入公式=IF(C2 方法三,在公式中借用数组,输入公式=ROUND(MAX((C2-3500)*0.05*{0.6,2,4,5,6,7,9}-5*{0,21,111...
round 函数答:{0,1,5,15,55,135,255,415,615}同样也表示一个数列。则((I4-SUM(K4:O4))-2000)*0.05*{1,2,3,4,5,6,7,8,9}-25*{0,1,5,15,55,135,255,415,615}得到的也是一个数列,我们不妨设为A数列。则MAX(A,0)表示A数列中所有数字和0当中的最大值,设为B。ROUND(B,2)...