excel绩效考核计算公式(excel绩效考核公式线性得分)

excel绩效考核计算公式(excel绩效考核公式线性得分)

首页维修大全综合更新时间:2025-04-27 14:36:40

excel绩效考核计算公式

用 lookup 函数,在绩效工资栏里输入公式=LOOKUP(B10,{0,50,60,65,75,80,85,90,95,100,105,110,200},{"0","40%","60%","75%","80%","90%","95%","100%","105%","110%","115%","120%"})其中B10是我试验表的位置,你可以改成相应的单元格位置

大家还看了
也许喜欢
更多栏目

© 2021 3dmxku.com,All Rights Reserved.