=IF(年级=6, IF( AND(Y7>=91,Y7<=100), "A+", IF( AND(Y7>=85,Y7<=90.9), "A", IF( AND(Y75>=80,Y7<=84.9), "B+", IF( AND(Y7>=70,Y7<=79.9), "B", IF( AND(Y7>=60,Y7<=69.9), "C", IF( AND(Y7>=50,Y7<=59.9), "D", IF( AND(Y7>=1,Y7<=49.9), "E", ""))))))),IF(年级=5, IF( AND(Y7>=91,Y7<=100), "A+", IF( AND(Y7>=85,Y7<=90.9), "A", IF( AND(Y75>=80,Y7<=84.9), "B+", IF( AND(Y7>=70,Y7<=79.9), "B", IF( AND(Y7>=60,Y7<=69.9), "C", IF( AND(Y7>=50,Y7<=59.9), "D", IF( AND(Y7>=1,Y7<=49.9), "E", ""))))))), IF( AND(Y7>=91,Y7<=100), "A+", IF( AND(Y7>=85,Y7<=90.9), "A", IF( AND(Y7>=80,Y7<=84.9), "B+", IF( AND(Y7>=70,Y7<=79.9), "B", IF( AND(Y7>=60,Y7<=69.9), "C", IF( AND(Y7>=50,Y7<=59.9), "D", IF( AND(Y7>=1,Y7<=49.9), "E", "")))))))))
我设置这个年级字段是数值类型,如果是文件类型,需要是 年级="4" ,其实就是多嵌两个IF IF(年级=6,公式2,IF(年级=5,公式2,公式1)) |