How to write script to get values

[#1]

Hi,

I need to get the column Type values in straight table as

If Type not equal to Cheque,DD,CreditCard then Type

Could anyone help me how to write statement.

Thanks.

[CELAMBARASAN · Accepted solution]

Try

If(Not MixMatch(Type, 'Cheque', 'DD', 'CreditCard'), Type)

[#3]

Hi,

Try this :

If(Match(Type, 'Cheque', 'DD', 'CreditCard') = 0, Type)

[#4]

Thanks it's working