Question

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

D5+E5+F5+G5大于等于70时，列I显示C，如果大于等于64，小于70列I则显示D。如果大于等于58，小于64列I则显示F，求解这个函数。谢谢帮忙！！

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

Answer 2

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

Answer 3

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

Answer 4

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

Answer 5

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