=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,"")))))))
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ号：24596024