用excel公式怎么表达差额定律累进法?就像计算个人所得税一样的。输入...答:假设数据在A1(数据单位为:元),试试下面公式:=SUMPRODUCT(TEXT(A1-{0,2000,1000001,10000001,50000001,100000001,1000000001},"0;\0")*{0,7,-3,-2.8,-0.4,-0.65,-0.05}/1000)
用excel公式怎么表达差额定律累进法?就像计算个人所得税一样的。输入...答:在B1中输入=IF(A1<100,A1*0.015,IF((A1>=100)*(A1<500),(A1-100)*0.011+1.5,IF((A1>=500)*(A1<1000),(A1-500)*0.008+5.9,IF((A1>=1000)*(A1<5000),(A1-1000)*0.005+9.9,IF((A1>=5000)*(A1<10000),(A1-5000)*0.0025+29.9,IF((A1>=10000)*(A1<100000),(...