Formula using OR - Would like to set a Range

[jase71ds]

I have a large table...
Each cell in the last column looks back to the left, across its row, and if "X" appears in any of those cells, it will return a value of "Yes".

What I'm currently doing works, but it's barbaric...
= IF (OR (A2="X",B2="X",...M2="X"), "Yes", "")

I'd like to set a simple range, like this...
= IF (OR (A2:M2 = "X"), "Yes"), "")
But it returns "#VALUE"

Any ideas on a simpler formula than what I'm currently using? Because it's a pain when I insert new columns in the middle of the table and then have to update the formula.

Thanks.
Jase.

 

[Fluff]

How about Countif
=IF(COUNTIF(A2:M2,"X"),"Yes","")

 

[jase71ds]

How about Countif
=IF(COUNTIF(A2:M2,"X"),"Yes","")

Wow! I learned something!! I've used Countif many times, but I never realized that you could nestle it within an If/Then in order to render a True or False verdict.

Thanks so much : )

 

[Fluff]

Glad to help & thanks for the feedback.

I think that most, if not all, xl functions can be nested

 

[jase71ds]

Yes, I knew that functions could be nestled, but what you showed me was that the nestling of COUNTIF changes what it does.
Example1: If cell G1 contains this formula =COUNTIF(A1:F1,"X") and if cells A1, C1,D1, and F1 contain "X", then the formula returns the answer "4". This is what I would expect.
However, what you showed me
Example2: If cell G1 contains this formula = IF(COUNTIF(A1:F1,"X"),"Yes","No") now COUNTIF appears to be telling the IF statement TRUE.
Anyway, I'm not explaining it well. I'll need to ponder this - it's powerful, but not at all intuitive to me.

 

[Jonmo1]

Not exactly...

COUNTIF is still returning 4

What's happening is that the IF is interpraiting 4 as TRUE
In a nutshel, 0 is FALSE, ANY NON 0 Number is TRUE

 

[Fluff]

Example2: If cell G1 contains this formula = IF(COUNTIF(A1:F1,"X"),"Yes","No") now COUNTIF appears to be telling the IF statement TRUE.

From memory, In logic 0 = False & 1 = true, my assumption is that in xl 0 =false & anything else = true