two value combined in field ,

[everest226]

Membership field has value = 'NOT PROVIDED','LOW ENTRY', 'Gold','Diamond', 'Silver','Cooper',

I want to two value in one,   like silver and cooper as silver and rest as usual , bellow is the syntax needed to be update

If(Upper([Membership])='NOT PROVIDED','LOW ENTRY',
Upper([Membership])) as [Membership],

[sunny_talwar · Accepted solution]

May be this?

If(Match(Upper(Membership), 'SILVER', 'COOPER'), 'silver', 'usual') as NewFieldName