用excel计算司龄工资?答:公式:=IF(B2>=6,IF(B2>=7,IF(B2>10,IF(B2>=12,IF(B2>=15,400,200+(B2-11)*50),200),(B2-5)*30),30),0)
如何利用公式计算司龄答:以B2单元格为例,公式为:=IF(DATEDIF(A2,TODAY(),"Y")>0,DATEDIF(A2,TODAY(),"Y")&"年","")&IF(DATEDIF(A2,TODAY(),"YM")>0,DATEDIF(A2,TODAY(),"YM")&"个月","")