关于Excel根据应发工资如何计算缴纳的个税,请写出公式(IF函数)
=IF(A1>=8000,0.1*(A1-3000),IF(A1>=5000,0.08*(A1-3000),IF(A1>=3000,0.05*(A1-3000),0)))
说明A1单元格是应发工资,所求的结果为扣税。不明白再问,ok?
=IF(A1>=8000,0.1*(A1-3000),IF(A1>=5000,0.08*(A1-3000),IF(A1>=3000,0.05*(A1-3000),0)))
说明A1单元格是应发工资,所求的结果为扣税。不明白再问,ok?