第1个回答 2009-08-12
在A1中输入你要查询的年月日(注意单元格要设置成日期格式),在B1中输入=IF(ROUNDDOWN(((YEAR(TODAY())-YEAR(A1))*12-MONTH(A1)+MONTH(TODAY()))/13,0)<1,0,(ROUNDDOWN(((YEAR(TODAY())-YEAR(A1))*12-MONTH(A1)+MONTH(TODAY()))/13,0)+1)*10).
搞定!
第2个回答 2020-05-17
"=IF(AND(A1>=3,A1<=10),80+(A1-3)*30,IF(A1>10,290,0))
a1是你的工龄."