If Statement with blank cells

[clemkonan]

I am requesting information which is entered at E4: K4 if all of the cells have text I need a formula at M4 that returns "Closed" otherwise, "open"
Key point in some cells may have blanks and should trigger the solution, " Open"
Thanks

 

[AliGW]

Is the contents of the cells text or numerical data?

 

[clemkonan]

Is the contents of the cells text or numerical data?

All text, thanks could be text, no or a chack mark

 

[AliGW]

Try this, then:

=IF(COLUMNS(E4:K4)-COUNTA(E4:K4)>0,"OPEN","CLOSED")

 

[Tetra201]

If cells in range E4:K4 contains formulas that might return "", then try the following:

=IF(ISERROR(FIND("||",E4&"|"&F4&"|"&G4&"|"&H4&"|"&I4&"|"&J4&"|"&K4)),"Closed","Open")

 

[Scott Huish]

Or possibly:

=IF(SUMPRODUCT(--(E4:K4="")),"Open","Closed")

 

[clemkonan]

Or possibly:

=IF(SUMPRODUCT(--(E4:K4="")),"Open","Closed")

Thanks the sum product approach was used and it worked well.