Calculated field with multiple exceptions

Hi,

I'm tying to calculate a mandatory field with several exceptions. The field has two exceptions from before and I can't figure out the formula for adding a third one. Could anyone help me with the correct formula?

Currently have:
and(and(isInList($atgard_reklamation_c,createList("BetalaUt","tillgodo"))
,not(isInList($avdelning_c,createList("Utemobler")))
),not(isInList($case_type_c,createList("goodwill","inlosentillgodo"))))

and need to add an additional exception based on a fourth drop-down field.

Thanks in advance!

Parents Reply Children