如何用excel表格算绩效(excel计算员工个人绩效合计数)

如何用excel表格算绩效(excel计算员工个人绩效合计数)

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

如何用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.