excel根据工龄换算工龄工资的公式答:1、工龄工资:在G3单元格输入以下公式,然后向下填充公式 =LOOKUP(F3,{0,1,3,5,10},{0,1,3,5,8}*100)2、在D2单元格输入以下公式,然后向下填充公式 =IF(B2<=C2,"超额完成",C2/B2)
EXCEL函数 如何计算工龄工资答:请在O6输入公式:=IF(DATEDIF(C6,DATE(YEAR(TODAY()),MONTH(TODAY()),15),"Y")<2,0,(DATEDIF(C6,DATE(YEAR(TODAY()),MONTH(TODAY()),15),"Y")-1)*50)下拉填充即可。
excel表格中如何用公式算工龄工资,答:设C2为入职日期,D2为工资结算截止日期如2015-6-30,E2为工龄工资,则在E2输入公式:=IF(DATEDIF(C2,D2+1,"m")<12,0,IF(DATEDIF(C2,D2+1,"Y")=1,100/DAY(D2)*DATEDIF(C2,D2+1,"yd"),(DATEDIF(C2,D2+1,"y")-1)*100))