excel if函数嵌套
发布网友
共4个回答
热心网友
可以，只是比较复杂，函数如下：
=IF(B1<60,IF(C1<60,IF(D1<60,"语文不及格，数学不及格，英语不及格","语文不及格，数学不及格"),IF(D1<60,"语文不及格，英语不及格","语文不及格")),IF(C1<60,IF(D1<60,"数学不及格，英语不及格","数学不及格"),IF(D1<60,"英语不及格","")))
热心网友
不用嵌套，只要把三个“IF”用“&”连接起来就能实现。在E2中输入公式：
“ =IF(B2<60,"数学不及格 ","")&IF(C2<60,"英语不及格 ","")&IF(D2<60,"语文不及格","") ”，E2公式向下复制。
热心网友
在E2输入公式，并向下复制
=MID(IF(B2<60,"，数学不及格","")&IF(C2<60,"，英语不及格","")&IF(D2<60,"，语文不及格",""),2,17)
热心网友
好像可以，但我也搞不清，不要误人子弟了
