Forum Discussion
Text If formula
I am trying to create a formula with an IF function and OR for around 37 different text options with 1 text result. EG =IF(A5=OR("ABC","DEF","GHI"AND SO ON),"XYZ","0") But am coming up with a #VALUE...
And yet another alternative that is closer to your original attempt:
=IF(OR(A5={"ABC","DEF","GHI",...etc...}), "XYZ", "0")
Caveat: Are you sure that you want the string "0", not the number zero (without double-quotes)?