excel2003关于个税的函数答:假设A1为未税金额 输入公式:=ROUND(MAX((A1-2000)*0.05*{1,2,3,4,5,6,7,8,9}-25*{0,1,5,15,55,135,255,415,615},0),2)
关于Excel根据应发工资如何计算缴纳的个税,请写出公式(IF函数)答:假如A列为工资,A2向下开始为工资数值,则B2输入公式如下,然后向下拉。=IF(A2>80000,A2*0.45,IF(AND(A2<=80000,A2>55000),A2*0.35,IF(AND(A2<=55000,A2>35000),A2*0.3,IF(AND(A2>9000,A2<=35000),A2*0.25,IF(AND(A2>4500,A2<=9000),A2*0.2,IF(AND(A2>1500,A2<=4500),A2...
MAX函数的使用问题答:公式为=MAX((A1-{1000,2000,5000})*{0.01,0.02,0.05}+{0,10,40},0)--- A1减去部分{1000,2000,5000})*{0.01,0.02,0.05},即A1- 10-40-250、然后和后面的0 10 40 合并 等于10-0,,40-10,250-40=10,30,210 采纳吧 骚年……...
哪位能教我下用Excel中用函数IF的一个公式来计算所得税?分7级的所有都...答:45% 13475 以上是最新个人所得税的扣税额度和税率及速算扣除数,用函数计算相应个税公式 设数字在A12单元格:=ROUND(IF((A12-3000)<0,0,MAX(ROUND((A12-3000)*{0.05,0.1,0.2,0.25,0.3,0.35,0.45}-{0,75,525,975,2725,5475,13475},6))),2)...