请问excel如何计算绩效等级 要求在第二张 谢谢

2025-03-18 17:17:53
推荐回答(1个)
回答1:

行号列标没照出来,绩效等级在K列,平均绩效在C23.
K2=IF(J2<=$C$23-100,"C",IF(AND($C$23-100
=J2),"B","A"))