求EXCEL工龄工资的公式?答:假设入场时间的2013-9-16在H5单元格且为日期格式,工龄工资=IF(DATEDIF(H5,TODAY(),"m")>=36,100,IF(DATEDIF(H5,TODAY(),"m")>=24,80,IF(DATEDIF(H5,TODAY(),"m")>=12,50,IF(DATEDIF(H5,TODAY(),"m")>=6,30,0)))
如何在excel里设置工龄公式,并计算工龄工资?答:一、计算工龄工资工式 =IF(DATEDIF(A3,NOW(),"m")>=3,"50",IF(DATEDIF(A3,NOW(),"m")>=12,"100",IF(DATEDIF(A3,NOW(),"m")>=24,"150",IF(DATEDIF(A3,NOW(),"m")>=36,"200","0")))二、计算工龄 1、=DATEDIF(A2,NOW(),"d") (天数)2、=DATEDIF(A2,NOW(),"m...
excel根据工龄换算工龄工资的公式答:1、工龄工资:在G3单元格输入以下公式,然后向下填充公式 =LOOKUP(F3,{0,1,3,5,10},{0,1,3,5,8}*100)2、在D2单元格输入以下公式,然后向下填充公式 =IF(B2<=C2,"超额完成",C2/B2)