IF函数全勤奖,请各位帮忙。我的公式在图片中(错误)。总共4等级,全勤奖为工资比例的11%

2024-12-02 13:39:30
推荐回答(3个)
回答1:

输入
=IF(AND(M4<=0.5,N4<=1,M4+N4<=1.5),0.11,IF(AND(M4<=1.5,N4<=2.5,M4+N4<=4),0.08,IF(AND(M4<=2.5,N4<=3.5,M4+N4<=6),0.04,0)))*工资单元格‍

回答2:

M4+N4是不是应该有括号?

回答3:

累计天数这个条件是怎么计算的?