aaa1

=DATEDIF(D2,TODAY(),"y")
=IF(MOD(MID(C2,17,1),2),"女","男")
=IF(G2="主管",300,250) + MIN(20, DATEDIF(D2,TODAY(),"y"))*100
=ROUND((H2+I2+J2+K2)/21.75,2)
=SUM(H2:K2)
=IF(病假天数<5, L2*病假天数*0.5, L2*病假天数*2)

作者: Anonymous

创建于: 2025-06-04 07:11

返回首页