名称成绩及评分Num_1Num_2Num_3Num_4
张三成绩50331560
评分5545
李四成绩401415-30
评分3342
王五成绩308-30-30
评分1112
C3
=IF(C$2=C$4,IF(C$4=C$6,3,IF(C$2>0,4,1)),IF(C$4=C$6,IF(C$2>0,5,2),IF(C$2=C$6,IF(C$2>0,5,2),IF(C$2=MAX(C$2,C$4,C$6),5,IF(C$2=MIN(C$2,C$4,C$6),1,3)))))
C5
=IF(C$2=C$4,IF(C$4=C$6,3,IF(C$4>0,4,1)),IF(C$4=C$6,IF(C$4>0,5,2),IF(C$2=C$6,IF(C$4>0,5,2),IF(C$4=MAX(C$2,C$4,C$6),5,IF(C$4=MIN(C$2,C$4,C$6),1,3)))))
C7
=IF(C$2=C$4,IF(C$4=C$6,3,IF(C$6>0,4,1)),IF(C$4=C$6,IF(C$6>0,5,2),IF(C$2=C$6,IF(C$6>0,5,2),IF(C$6=MAX(C$2,C$4,C$6),5,IF(C$6=MIN(C$2,C$4,C$6),1,3)))))