Help with simple Expression please

[Doors]

Hi,

How would I combine the following two expressions into one?

ISNOTBLANK([Dinner])

CONTAINS([Dinner], {“Meat”, “Veg”, “Special”})

Thanks, J.

[WillowMobileSys · Accepted solution]

Use one of the logical functions AND() or OR() depending on your need.

If you needed both to be true, the your expression would look like this:

AND(ISNOTBLANK([Dinner]),
    CONTAINS([Dinner], {“Meat”, “Veg”, “Special”})
 )

By the way, I don’t think CONTAINS() is the function you want. CONTAINS() is meant to test for a substring is contained within another string.

The function you really want is IN([Dinner], {“Meat”, “Veg”, “Special”})

[Doors]

Great, Thanks. I’ll get the hang of this one of these days.