excel怎么通过使用函数使A1B1C1D1...成为F1的判断条件。如果A1=50，B1=50，C1=50，那么D1=巩固？

Question

请高人帮助，能让某单元格通过自动判断与其在同一行的前面多列的值，来自动填充一个值，如果前面是第一种情况，返回一个值，是第二种情况，返回第二个值，第三种情况，返回第三个值........

Answer 1

在D1单元格输入以下公式
=IF(COUNTIF(A1:C1,50)=3,"巩固",IF(COUNTIF(A1:C1,50)=2,"提高",IF(COUNTIF(A1:C1,50)=1,"加强","重新")))

Answer 2

=if(sum(A1:C1)=150,"巩固",if(sum(a1:C1)=140,"提高",if(sum(a1:c1)=130,"加强","重新")))
或者
=choose(sum(a1:c1)/10-11,"重新","加强","提高","巩固")本回答被提问者采纳

Answer 3

D1输入
=CHOOSE(COUNTIF(A1:C1,50)+1,"重新","加强","提高","巩固")