• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Better Formula for OR function


New Member

=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)

Peter Bartholomew

Well-Known Member
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.