EXCEL函数问题，求朋友们帮帮忙。谢谢大家！！

2024-12-05 06:54:27

推荐回答（5个）

回答1：

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单元格复制下拉。

回答2：

I5中输入
=indirect(lookup(sum(D5:G5), {58,64,70},{"F5","D5","C5"}))

回答3：

=if(D5+E5+F5+G5>=70,"C",if(D5+E5+F5+G5>=64,"D",if(D5+E5+F5+G5>=58,"F")))

回答4：

=IF(SUM(D5:G5)<64,"F",IF(SUM(D5:G5)<70,"D","C"))

回答5：

=if(D5+E5+F5+G5>=70,C,if(D5+E5+F5+G5>=64,D,if(D5+E5+F5+G5>=58,F)))