大漠流沙 2022-01-06 15:59 回复 赞(0) 3楼
能不能看懂看自己基础了,贴到a1单元格上去,应该可以明白。
工龄文字 | 工龄(年) | 公式 |
1月 | =1/12 | =LOOKUP(B2,{0.0833333,0.1666667,0.5,1,3;0,0.5,0.8,1,1.1}) |
2月 | =2/12 | =LOOKUP(B3,{0.0833333,0.1666666,0.5,1,3;0,0.5,0.8,1,1.1}) |
6月 | =6/12 | =LOOKUP(B4,{0.0833333,0.1666667,0.5,1,3;0,0.5,0.8,1,1.1}) |
1年 | =12/12 | =LOOKUP(B5,{0.0833333,0.1666667,0.5,1,3;0,0.5,0.8,1,1.1}) |
3年 | =36/12 | =LOOKUP(B6,{0.0833333,0.1666667,0.5,1,3;0,0.5,0.8,1,1.1}) |