"If any one of those cells is blank then do this" How to formulate?

[Kukorof]

Hi,

Suppose I have some data in A2 C2 & E2. In F2 I want to put a formula where it shows that if any one of those three separate cells (which is not in a range) contains a blank then show X in F2. I could do it with multiple nested IF functions (=If(A2="", "X", If(C2="", "X", If(E2="", "X", "Other formula")))). But in that formula the "X" is repeated to many times for the same purpose for larger number of columns. SO I wonder if there is any other method producing the same result but that is way more efficient than that?


regards

 

[fhqwgads]

=IF(OR(A2="",C2="",E2=""),"X","Other formula")

 

[Kukorof]

=IF(OR(A2="",C2="",E2=""),"X","Other formula")

Many thanks!

 

[Peter_SSs]

This would allow you to expand to any number of columns without adding more terms to it, just altering the overall range.

=IF(SUMPRODUCT(--(A2:E2=""),--(MOD(COLUMN(A2:E2)-COLUMN(A2),2)=0)),"X","Other formula")

Expansion example:
=IF(SUMPRODUCT(--(A2:Q2=""),--(MOD(COLUMN(A2:Q2)-COLUMN(A2),2)=0)),"X","Other formula")