Not equal to for normal expression

[Anonymous]

Hi,

Could you please let me know, how to make this as not equal to for the same expression.

=

if(Business_Source_Name='R' or Business_Source_Name='M' or Business_Source_Name='D"or Business_Source_Name='C',Business_Source_Name

)

This give me correct only based on the given list but if I want to not take all those except all then how to take?

Need help.

Best Regards,

Skumar

[swuehl · Accepted solution]

Try

=if( not match(Business_Source_Name,'R','M','D','C'), Business_Source_Name)

[Anonymous]

Excellent !!It works. Thanks a ton

[#4]

/= works well for not equal to

if(Business_Source_Name/='R' or Business_Source_Name/='M' or Business_Source_Name/='D"or Business_Source_Name/='C',Business_Source_Name

)