=if(COMPANY='PT.TDS TECHNOLOGY',COMPANY) How to add one more company ?

[paulyeo11]

Hi All

Below expression in Table 1 working fine :-

=if(COMPANY='PT.TDS TECHNOLOGY',COMPANY)

I try to add one more company Table 2 , i get error :-

=if(COMPANY='PT.TDS TECHNOLOGY'&'TDS TECHNOLOGY (KL) SDN BHD',COMPANY)

May i know where i go wrong ?

Paul

[paulyeo11]

my qvw

[sunny_talwar · Accepted solution]

Try this:

=if(Match(COMPANY, 'PT.TDS TECHNOLOGY', 'TDS TECHNOLOGY (KL) SDN BHD'), COMPANY)

or this:

=if(COMPANY = 'PT.TDS TECHNOLOGY' or COMPANY = 'TDS TECHNOLOGY (KL) SDN BHD', COMPANY)

[Digvijay_Singh]

something like this -

=if(COMPANY='PT.TDS TECHNOLOGY' and COMPANY='TDS TECHNOLOGY (KL) SDN BHD',COMPANY)

[MK_QSL]

use Match function here..

IF(Match(YourFieldName,'Value1','Value2','Value'3), Result1,Result2)

[paulyeo11]

‌Hi All

thank you every one for your help .

NOw okay

paul