关于Excel根据应发工资如何计算缴纳的个税，请写出公式（IF函数）

发布网友发布时间：2023-05-06 01:53

共2个回答

热心网友时间：2023-11-18 07:14

=IF(A1>=8000,0.1*(A1-3000),IF(A1>=5000,0.08*(A1-3000),IF(A1>=3000,0.05*(A1-3000),0)))
说明A1单元格是应发工资，所求的结果为扣税。不明白再问,ok?

热心网友时间：2023-11-18 07:14

=IF(A1<3000,0,IF(A1<5000,(A1-3000)*0.05,IF(A1<8000,(A1-3000)*0.08,(A1-3000)*0.1)))

热心网友时间：2023-11-18 07:14

=IF(A1>=8000,0.1*(A1-3000),IF(A1>=5000,0.08*(A1-3000),IF(A1>=3000,0.05*(A1-3000),0)))
说明A1单元格是应发工资，所求的结果为扣税。不明白再问,ok?

热心网友时间：2023-11-18 07:14

=IF(A1<3000,0,IF(A1<5000,(A1-3000)*0.05,IF(A1<8000,(A1-3000)*0.08,(A1-3000)*0.1)))

热心网友时间：2023-11-18 07:14

=IF(A1>=8000,0.1*(A1-3000),IF(A1>=5000,0.08*(A1-3000),IF(A1>=3000,0.05*(A1-3000),0)))
说明A1单元格是应发工资，所求的结果为扣税。不明白再问,ok?

热心网友时间：2023-11-18 07:14

=IF(A1<3000,0,IF(A1<5000,(A1-3000)*0.05,IF(A1<8000,(A1-3000)*0.08,(A1-3000)*0.1)))