Convert If(Or string to Arrays

[Judoman]

I have a formula that lists several cells to look for the letter X. If X is in any single cell a text is displayed "Package Price" in K25.

Need formula to be converted from strings of cells to arrays.
Current formula: If(OR(E41=”X”,E42=”X”,E43=”X”,),”Package Price”,””)

Need new formula to make array of E41:E47, add another array of E57:E67 in the same formula, if any cell in arrays has an X then K25 should show "Package Price".

I used =IF(E41:E47, "X","Package Price","") But it only shows text when X is in E41

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Judoman]

Good point. I use 3 different computers with 3 different Excel versions. In this case I'm using Excel 2016. Thanks for the headsup.

 

[Fluff]

Thanks for that.
How about

=IF(OR(COUNTIFS(E41:E47,"x"),COUNTIFS(E57:E67,"x")),"Package Price","")

 

[Judoman]

Works Perfectly.

Thanks for your help and quick response.

 

[Fluff]

You're welcome & thanks for the feedback.