# Difficult Formula Question.

#### omairhe

##### Well-known Member
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 = ""

Code:
``[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.

Last edited:

### Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

#### Misca

##### Well-known Member
Try concatenating the cell values. Then substitute spaces with "". And check if the text length equals 0.

Replies
1
Views
187
Replies
5
Views
188
Replies
1
Views
143
Replies
3
Views
132
Replies
2
Views
162

1,196,027
Messages
6,012,954
Members
441,740
Latest member
abaz21

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back