excel中病事假扣除天数的函数公式答:=IF(I2="病假",IF(J2<=10,0,IF(J2<20,J2,30)),IF(I2="事假",IF(J2<=1,0,IF(J2<10,J2,30)),IF(I2="旷工",30,"")))
求excel公式考勤表中 事假一天扣全额工资 病假扣50%,婚假,丧假不扣...答:答案一 =IF(B2="事假",A2/30*C2,IF(B2="病假",A2/60*C2,0))答案二 =IF(B2="病假",A2/60*C2 ,IF(B2="事假",A2/30*C2,0))答案三 =IF(OR(B2="",B2="婚假",B2="丧假"),0,IF(B2="病假",A2/60*C2,A2/30*C2))答案四 =IF(OR(B2="",B2="婚假",B2="丧假"),0,IF...
Excel中,请假天数小于4天,不扣奖金,超过3天,病假每天扣除奖金10元,事假...答:你这个表有点奇特哦,意思是一个人一个月只请一种假吗,万一2天病假、1天事假怎么弄呢?好吧,按照你的规则,扣奖金公式为:=IF(K2<4,0,IF(K2>10,H2,K2*IF(J2="事假",20,5)))效果如下: