Can someone please help me out with this formula? In English I’m trying to say:
If the words “CANCEL”, “Cancel – Non-Pay”, or “Cancel-Pend Rel/NOC” are in column A, then count as 1, if not 0..
This is what I thought was right…Apparently not..
=IF(or(A:A=”CANCEL”,”Cancel – Non-Pay”,”Cancel-Pend Rel/NOC”,1,0))
What did I do wrong?
Bookmarks