Hello - I am looking for help with the following. Thanks in advance!
I have a column with values that need to be categorized based on multiple criteria. I would like to categorize using below logic:
If value contains "X" Or "Y", categorize as "Category1", if contains "A" or "B" or "C" categorize as Category2, if contains "M" or "N" or "O", categorize as category 3, else "other"
Can I use the IF OR statement for this?
Thanks!
I have a column with values that need to be categorized based on multiple criteria. I would like to categorize using below logic:
If value contains "X" Or "Y", categorize as "Category1", if contains "A" or "B" or "C" categorize as Category2, if contains "M" or "N" or "O", categorize as category 3, else "other"
Can I use the IF OR statement for this?
Thanks!