Calculated field from multiple IF/OR statements I am trying to create what I thought was a simple nested IF statement calculation to populate one choice if one or more options of a multi-select field are selected, another is displayed if different options are selected and both are displayed if there is overlap. The quick example I started with is below. I'm not sure if the OR operator is the correct choice or if I'm even going in the right direction here. I realize that there isn't a "false" value on these and maybe that's part of it, but I have tested it without success.
IF({DE:Deliverable Type}="Autoship","Marcomm"||IF({DE:Deliverable Type}="Blog","Marcomm"||IF({DE:Deliverable Type}="Brand Design","Marcomm"||IF({DE:Deliverable Type}="Packaging","Ecomm"))))
So, if one or more of the first three IFs are true, I want the calcuation to indicate Marcomm. If the last is true, I want it to say Ecomm. If any of the first three and the last one are true, I want it to say both. There are several