=IF(K3>80000,K3*45%-13505,IF(K3>55000,K3*35%-5505,IF(K3>35000,K3*30%-2755,
IF(K3>9000,K3*25%-1005,IF(K3>4500,K3*20%-555,IF(K3>1500,K3*10%-105,K3*3%-0))))))\

=IF(K3<=1500,K3*[工资薪金所得税率.xlsx]Sheet1!$B$2-[工资薪金所得税率.xlsx]Sheet1!$C$2,IF(K3>1500,K3*[工资薪金所得税率.xlsx]Sheet1!$B$3-[工资薪金所得税率.xlsx]Sheet1!$C$3,IF(K3>4500,K3*[工资薪金所得税率.xlsx]Sheet1!$B$4-[工资薪金所得税率.xlsx]Sheet1!$C$4,IF(K3>9000,K3*[工资薪金所得税率.xlsx]Sheet1!$B$5-[工资薪金所得税率.xlsx]Sheet1!$C$5,IF(K3>35000,K3*[工资薪金所得税率.xlsx]Sheet1!$B$6-[工资薪金所得税率.xlsx]Sheet1!$C$6,IF(K3>55000,K3*[工资薪金所得税率.xlsx]Sheet1!$B$7-[工资薪金所得税率.xlsx]Sheet1!$C$7,K3*[工资薪金所得税率.xlsx]Sheet1!$B$8-[工资薪金所得税率.xlsx]Sheet1!$C$8))))))