全站数据
8 4 2 0 5 8 1

excel绩效考核计算公式

财务一点通 | 教育先行,筑梦人生!         
问题更新日期:2024-05-13 15:34:58

问题描述

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是我试验表的位置,你可以改成相应的单元格位置