假设入职日期在A2在B2中输入或复制粘贴下列公式=IF(A2="","",LOOKUP(DATEDIF(A2,TODAY(),"Y"),{0,1,2,3,4,5},{0,50,100,200,300,400}))下拉填充
先求出司龄：=DATEDIF(A1,NOW(),"y")工资就好计算了。
=if(a2<=2,a2*50,(a2-1)*100)
=if(a1>=3,a1*100-100,if(a1>=1,a1*50,0))
