If Statement with multiple conditions

[billpq]

How do I do something like this, which I know doesn't work, without having to type out my lengthy formula multiple times:

=if(lengthy formula = 1 or 5 or 7, "YES", "NO")

I know I can do, but this requires my lengthy formula repeated 3 times in the condition:

=if(or(lengthy formula=1, lengthy formula=5, lengthy formula=7),"YES","NO")

Thanks!

 

[barry houdini]

Try using OR function like this

=if(OR(lengthy formula={1,5,7}),"YES","NO")

 

[jeffreybrown]

Maybe...

=IF(OR(LEN(E2)={1,5,7}),"Yes","No")

 

[billpq]

Thank you... I wasn't familar with the {} brackets. Works perfectly!