I5显示C5,还是到整个I列?
如果是I5则请输入公式:
=IF(D5+E5+F5+G5>=70,"C",IF(D5+E5+F5+G5>=64,"D",IF(D5+E5+F5+G5>58,"F","")))
如果是整个I列,则请在I1输入公式:
=IF($D$5+$E$5+$F$5+$G$5>=70,"C",IF($D$5+$E$5+$F$5+$G$5>=64,"D",IF($D$5+$E$5+$F$5+$G$5>58,"F","")))
并将I1单元格复制下拉。
I5中输入
=indirect(lookup(sum(D5:G5), {58,64,70},{"F5","D5","C5"}))
=if(D5+E5+F5+G5>=70,"C",if(D5+E5+F5+G5>=64,"D",if(D5+E5+F5+G5>=58,"F")))
=IF(SUM(D5:G5)<64,"F",IF(SUM(D5:G5)<70,"D","C"))
=if(D5+E5+F5+G5>=70,C,if(D5+E5+F5+G5>=64,D,if(D5+E5+F5+G5>=58,F)))