设置Excel计算分数出绩效分数公式?

2025-02-19 07:08:39
推荐回答(2个)
回答1:

=IF(B2<91,B2/91,IF(B2>95,B2/95,1))

回答2:

=IF(B2<91,B2/91)
=IF(B2>95,B2/95)
=IF(91≥B2≤95,1)

望采纳谢谢