エクセル IF関数でFALSEを表示させない（備忘録）

（備忘録）

エクセル　IF関数でFALSEを表示させない

1の入っているところに条件の値，入ってないところは空白とする

=IF(A1<>"","～","")

【IF関数】
IF(条件,条件に一致したときの答え,一致しないときの答え）
です。


こんな条件検索を作った。

=IF(E7<>"",$E$5,"")
&IF(F7<>"",$F$5,"")
&iF(G7<>"",$G$5,"")
&IF(h7<>"",$h$5,"")
&IF(i7<>"",$i$5,"")
&IF(j7<>"",$j$5,"")
&IF(k7<>"",$k$5,"")
&IF(l7<>"",$l$5,"")
&IF(m7<>"",$m$5,"")
&IF(n7<>"",$n$5,"")
&IF(o7<>"",$o$5,"")
&IF(p7<>"",$p$5,"")
&IF(q7<>"",$q$5,"")
&IF(r7<>"",$r$5,"")
&IF(s7<>"",$s$5,"")
&IF(t7<>"",$t$5,"")
&IF(u7<>"",$u$5,"")
&IF(v7<>"",$v$5,"")
&IF(w7<>"",$w$5,"")
&IF(x7<>"",$x$5,"")
&IF(y7<>"",$y$5,"")
&IF(z7<>"",$z$5,"")
&IF(aa7<>"",$aa$5,"")
&IF(ab7<>"",$ab$5,"")
&IF(ac7<>"",$ac$5,"")
&IF(ad7<>"",$ad$5,"")
&IF(ae7<>"",$ae$5,"")
&IF(af7<>"",$af$5,"")
&IF(ag7<>"",$ag$5,"")
&IF(ah7<>"",$ah$5,"")
&IF(ai7<>"",$ai$5,"")
&IF(aj7<>"",$aj$5,"")