salesforce - Field formula with Case/If statement

Question

I want to set a formula for a field C by check two picklist fields A and B (the value in the picklist will Yes, No, None)

 If field A = "Yes" and field B = "Yes"  then field C = "1"
 If field A = "Yes" and field B <> "Yes"  then field C = "2"
 If field A <> "Yes" and field B = "Yes"  then field C = "3"
 If field A <> "Yes" and field B <> "Yes"  then field C = "4"

I don't know how to set a formula for field C to make it works, I try CASE, IF statement without any luck.

Any help will be appreciated.

Thanks,

question from:https://stackoverflow.com/questions/65838553/field-formula-with-case-if-statement

Answer 1

I would suggest to spend some times on these trailhead: Use Formula Fields and Advanced Formulas.
Bookmarking Formula Operators and Functions documentation page would be useful too.

Since A and B are picklist fields you must use ISPICKVAL(field, value).
If C is a text formula field:

IF( ISPICKVAL(A, 'Yes'),
    IF ( ISPICKVAL(B, 'Yes'),
        '1',
        '2'
    ),
    IF ( ISPICKVAL(B, 'Yes'),
        '3',
        '4'
    )
)