+ Start a Discussion
Steve HarrisonSteve Harrison 

Help with a formula!

I'm having trouble creating the correct syntex for a formula field. I have one piece working, which involves inserting a value if another multipick list field has a specific value selected.

(IF(INCLUDES(Account_Types__c , "Clinical"),"Clinical", " "))

But I also want to insert other values if other picklist options are selected. I tried adding an OR operator or OR function but just can't find the correct syntax. For example...

(IF(INCLUDES(Account_Types_c, "Clinical"),"Clinical"," ") OR (IF(INCLUDES(Account_Types__c , "Pharma/Biotech"),"Pharma/Biotech", " "))

Much thanks in advance!

Steve

Best Answer chosen by Steve Harrison
YuchenYuchen
You can try the following:

IF(INCLUDES(Account_Types_c, "Clinical"), "Clinical", IF(INCLUDES(Account_Types__c , "Pharma/Biotech"), "Pharma/Biotech", ""))

Thanks.

All Answers

YuchenYuchen
You can try the following:

IF(INCLUDES(Account_Types_c, "Clinical"), "Clinical", IF(INCLUDES(Account_Types__c , "Pharma/Biotech"), "Pharma/Biotech", ""))

Thanks.
This was selected as the best answer
Steve HarrisonSteve Harrison
That did it. Thanks!

Steve