excel工龄工资计算函数答:在excel里设置工龄公式,并计算工龄工资的方法如下:1、计算工龄的公式如下:=DATEDIF(A2,NOW(),"y")2、计算工龄工资的公式如下:=IF(DATEDIF(A2,NOW(),"y")>8,135+(DATEDIF(A2,NOW(),"y")-1)*10,IF(DATEDIF(A2,NOW(),"y")>0,30+(DATEDIF(A2,NOW(),"y")-1)*15,0))上面公式...
求Excel表格中工龄工资函数公式!答:B2*20,IF(B2<=20,200+(B2-10)*30,IF(B2<=30,500+(B2-20)*40,IF(B2<=35,900+(B2-30)*50,1200)))或者:=IF(B2<=10,20*B2,IF(B2<=20,30*B2-100,IF(B2<=30,40*B2-300,IF(B2<=35,50*B2-600,1200)))B2单元格输入工龄,C2单元格输入计算工龄工资的公式,下拉 ...