And/or

Hi All,

When I use AND/OR function how to simplify it to have a shorter function? For example how can I simplify =IF(OR(A1="a",A1="b",A1="c"),"d","e") to something like =IF(A1=OR(a,b,c),"d","e")?

Thanks

Like this:

=IF(OR(A1={"a","b","c"}),"d","e")

Thanks falcondude

You're welcome. Thanks for the rep!