About this question
Am trying to build a formula field with multiple IF conditions, so decided to go with Case function, below is the return statement based on the picklist value
0 Member
2 Member
3 Member
22 Only a Member if the "Date__c" field is not blank, otherwise Non-Member
23 Non-Member
27 Only a Member if the "Date__c" field is not blank, otherwise Non-Member
70 Only a Member if the "Date__c" field is not blank, otherwise Non-Member
80 Only a Member if the "Date__c" field is not blank, otherwise Non-Member
85 Non-Member
87 Only a Member if the "Date__c" field is not blank, otherwise Non-Member
90 Only a Member if the "Date__c" field is not blank, otherwise Non-Member
99 Member
So I created something like
CASE(TEXT(MDPKG__Status_Code__c),
'00', 'Member',
'02', 'Member',
'03', 'Member',
'99', 'Member',
'23', 'Non-Member',
'85', 'Non-Member',''
)
Couldn't Find a way to check those If conditions inside case function (Is it possible?) Should I use a different function ?
