确定税前收入某列例为A1：超过起征点例B1=IF(A1>2000,A1-2000,0)税率C1=IF(B1=0,0,IF(B1<=500,5%,IF(B1<=2000,10%,IF(B1<=5000,15%,IF(B1<=20000,20%,IF(B1<=40000,25%,IF(B1<=60000,30%,IF(B1<=80000,35%,))))))))速算扣除列D1=IF(B1<=500,0,IF(B1<=2000,25,IF(B1<=5000,125,IF(B1<=20000,375,IF(B1<=40000,1375,IF(B1<=60000,3375,IF(B1<=80000,6375,IF(B1<=100000,10375,1
|
