Better Formula for OR function

[Caravishah]

Hi,

=if(OR(a1 = "X", b1 ="X", c1 ="X"), value if true, value if false)

Is there a way to write this formula without 3 logic for OR?

tried below but does not work

=if(OR(a1, b1, c1) = "X", value if true, value if false)

 

[Fluff13]

How about
=IF(COUNTIF(A1:C1,"X")>0,"yes","no")

 

[Caravishah]

works. thanks

 

[Fluff13]

You're welcome & thanka for the feedback.

 

[Peter Bartholomew]

Closer to your original concept
= IF( OR(A1:C1="X"), "Yes", "No" )
On past versions of Excel, I think the formula has either to be committed with CSE or used within a defined name.