考勤表偷懒合集

=IF(ADD>=94.5%,"A",IF(ADD>=84.5%,"B",IF(ADD>=74.5%,"C",IF(ADD>=64.5%,"D",IF(ADD>=54.5%,"E",IF(ADD=0%," ","F"))))))

实际使用时替换ADD为需要检查的行列号

满足

• A [95,100]
• B [85,95)
• C [75,85)
• D [65,75)
• E [55,65)
• F [0,55)