Looking for some help creating this formula: I am struggling with the multiple AND where not all requires AND.
To Be Logic:
- IF Field_1_c = "Value_A__c" put an "a"
- IF Field_1_c = "Value_B__c" put a "j"
- IF Field_1_c = "Value_C__c" AND Field_2__c does NOT = “A Value” put a “p”
- IF Field_1_c = "Value_C__c" AND Field_2__c = “A Value” put a “r”
- If none of these conditions are met, put in a "p"
Please assist.
Thank You!
3 respuestas
Hi,
Use the following formula.
IF( Field_1_c = "Value_A__c", "a",
IF( Field_1_c = "Value_B__c", "j",
IF( AND(Field_1_c = "Value_C__c", Field_2__c != "A Value"), "p",
IF( AND(Field_1_c = "Value_C__c", Field_2__c = "A Value"), "r",
"p"
)
)
)
)
