单位满2年工龄工资增加200元/月,以后每满1年再增资80元/月,1000元封顶...答:所需公式可参考图示:C3=DATEDIF(B3,DATE(YEAR(TODAY()),MONTH(TODAY()),10),"M")/12 D3=IF(C3<2,0,MIN(200+INT(C3-2)*80,1000))E3=IF(DATEDIF(B3,DATE(YEAR(TODAY()),MONTH(TODAY()),10),"M")/12<2,0,MIN(200+INT(DATEDIF(B3,DATE(YEAR(TODAY()),MONTH(TODAY()),10),...