=(IF(AND(B2=0),0,IF(AND(B20,B21500),ROUND(B2*3%,2),IF(AND(B2=1500,B24500),ROUND(B2*0.1-105,2),IF(AND(B2=45000,B29000),ROUND(B2*0.2-555,2),IF(AND(B2=9000,B235000),ROUND(B2*0.25-1005,2),IF(AND(B2=35000,B255000),ROUND(B2*0.3-2755,2),IF(AND(B2=55000,B280000),ROUND(B2*0.35-5505,2),\"\"))))))))B2为应纳税所得额,即=应得工资-3500-五险一金追问谢谢你,能否发个截图,因为点开出入函数IF后。出现三行:逻辑值、任意、任意,我不知道这些怎么区分。
|