Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try
=if( not match(Business_Source_Name,'R','M','D','C'), Business_Source_Name)
Try
=if( not match(Business_Source_Name,'R','M','D','C'), Business_Source_Name)
Excellent !!It works. Thanks a ton
/= 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
)