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
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!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks