=LOOKUP(A1,{1,2,3,10,20},{5,6,7,10,15}),A1字段放工龄
=LOOKUP(A1,{1,2,3,4,10,11,20},{7,8,9,10,11,12,15})
=if(A1>=20,15,if(A1>=10,10,if(A1>=3,7,if(A1>=2,6,if(A1>=1,5,"")))))
=if(A1>=20,15,if(A1>=11,12,if(A1>=10,11,if(A1>=4,10,if(A1>=3,9,if(A1>=2,8,if(A1>=1,7,"")))))))