IF/OR Statements, Sharepoint Lists

Question

I know variations of this question have been asked, but have been unsuccessful applying the logic of those threads to my situation:

I am in need of assistance creating a multiple "if/or" statements for a sharepoint list calculated column. I'd like the list to say =IF(OR([Column]=value1,value2,value3,“true value”, and then repeat for the same column, different values and output. This will repeat 8 times. Specifically, I need it to say: "If submitter column contains CB, or AC, or RL, then populate with Sales; if submitter column contains SH, or AC, or BK, then populate with Supply Chain; if submitter column contains EB, or BF, or CM, populate with Retail. etc, etc

So far I have:
=IF(OR([Submitter ]="CB","AC","RL"),"Sales"

Any guidance would be greatly appreciated!

Answer 1

Hi @TE ,
I want to confirm with you that the two "AC" mentioned in the original post are used as conditions but fill in two different contents. Is it an example error?

The formula is:
=IF(OR(submitter="CB",submitter="AC",submitter="RL"),"Sales",IF(OR(submitter="SH",submitter="AC",submitter="BK"),"Chain Supply",IF(OR(submitter="EB",submitter="BF",submitter="CM"),"Retail","")))
The following is the function realization effect diagram.

If the two occurrences of "AC" need to implement other functions, please contact me.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.