Initial Values_MV

Dear Friends,
The formula checking only DANGEROUS GOODS word. What formula could be if I want to check the “DANGEROUS GOODS” and “CONSOL” words together?

IFS(
CONTAINS(
[COMMODITY TYPE],
{“DANGEROUS GOODS”}
),“DGR”
)

1 Like
2 Likes

Do not know. That’s why i am asking.

Try this