Multi-select picklist to give additional value

Question

I am trying to edit one formula to have one additional value in the specific result. Basically I've added additional value in the multi-select picklist (N/A), and I want that value to give the same result as the No value in the multiselect picklist.

I am working with the following code:

IF(ISBLANK(Video_Monetizing_tool__c),NULL,IF(INCLUDES(Video_Monetizing_tool__c,"No"),0,10))

This is related to : Giving formula values with multi-select picklist

Please advise,

Darko

Answer 1

regarding your formula here is a short explanation:

IF (ISBLANK(Video_Monetizing_tool__c), // if video monetizing tool != null
    NULL, // return null
    IF(INCLUDES(Video_Monetizing_tool__c,"No"), // else return if Video Monetizing = no
    0, // 0
    10 // otherwise return 10
    )
)

In order to extend the existing functionality we have to exit the line IF(INCLUDES(Video_Monetizing_tool__c,"No"),. The if argument has to be true in case Video_Monetizing_tool__c is contains to "No" or contains "N/A". Therefore we can use the OR() operator.

[OR] evaluates if at least one of multiple values or expressions is true. Use this operator as an alternative to the logical function OR. - SFDC Documentation

The result looks like this: IF(OR(INCLUDES(Video_Monetizing_tool__c,"No"), INCLUDES(Video_Monetizing_tool__c,"N/A")),

And this is the final result:

IF (ISBLANK(Video_Monetizing_tool__c),
    NULL,
    IF(OR(INCLUDES(Video_Monetizing_tool__c,"No"), INCLUDES(Video_Monetizing_tool__c,"N/A")), 
    0,
    10
    )
)