LinkBack URL
About LinkBacks
Is it possible to do a simple IF statement on a list of criteras, rather than doing an IF for each individual outcome, as per attached
Is it possible to do a simple IF statement on a list of criteras, rather than doing an IF for each individual outcome, as per attached
yes but you need the OR function
=IF(OR(A2={"a","c","e"}),"Yes","No")
Josie
if at first you don't succeed try doing it the way your wife told you to
Cheers chap
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks