8.利用函数求出是否扣税(实发工资大于5000的就扣税,否则不扣税)

2024-11-15 06:50:35
推荐回答(2个)
回答1:

=IF(H3>5000,"扣税",“不扣税”)
下拉

回答2:

I3=IF(H3>5000,"是","否")
填充柄下拉。