Caravishah
New Member
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)
=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)