知道应缴个人所得税税额倒算工资 ,求EXCEL公式。答:税后工资倒推税前工资Excel计算公式 倒推税前1=MAX((实发-5000-{0,210,1410,2660,4410,7160,15160})/(1-{3,10,20,25,30,35,45}%)+5000,实发)+SUM(扣除的几险几金)倒推税前2=MIN((税金+{0,210,1410,2660,4410,7160,15160})/{3,10,20,25,30,35,45}%)+5000+SUM(社保)即:=M...
求用Excel公式,根据税后收入,反推扣除劳务所得税前的税前金额!答:B2单元格输入=ROUND(MAX((C2-3500)*0.05*{0.6,2,4,5,6,7,9}-5*{0,21,111,201,551,1101,2701},0),2)C2单元格输入=A2+B2 (即税前收入=税后收入+所得税)输完后Excel显示 打开Excel选项,在公式中勾选“启用迭代计算”,并在A2中输入40000,显示税前收入为51707.14元。
求:税后年终奖倒推税前金额的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%))...