用差额定率累进计费excel答:1、若A2是 以万元为单位的数值,则可在B2单元格输入公式:=SUM(100*TEXT(A2-{0,100,200,500,1000,3000},"0;!0")*{1.5,-0.3,-0.1,-0.3,-0.3,-0.1})2、若A2是以元为单位的数值,则B2单元格可用公式:=SUM(TEXT(A2-{0,100,200,500,1000,3000}*10000,"0;!0")*{1.5,...
用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)