Difficult Formula Question.

[omairhe]

Hello,

I have a formula that would output me text = "Excess" if a given range of cells are empty. However I would like to add a second condition to the existing formula. Condition being if the cells have also blank space or spaces in them then output text = "Excess" aswell.

for instance the range consists of the following values

Note:- (, indicate next cell value in range)

"", "", " ", " ",

output ="Excess"

3, " ", "",

output = ""

"", "", "", "",

output = "Excess"

" ", " ", " ",

output = "Excess"

"next day", "", " ",

output = ""

[FONT=Verdana]=IF(OR(Z7="",SUMPRODUCT(--(ISNUMBER(SEARCH("*?",T7:Y8&AI7:BF8))))),"","Excess")[/FONT]

T7:Y8&AI7:BF8 = is my range​

I hope I did ok to explain my requirement.



Will appreciate any help.

Thanks a lot.

 

[Misca]

Try concatenating the cell values. Then substitute spaces with "". And check if the text length equals 0.