if condition with or not working

[#1]

Hi All,

I have this condition which is not working.

if(wildmatch(Country,'United States of America','China','Taiwan','Germany (Federal Republic of)', 'Netherlands')>0 AND match(Status,'Allowed','Granted')

and (InventionValue<3 or Tag LIKE '*Apple_Tabled*' or (Company='Apple' and match(IFSCORE,'1','2'))), 'Tabled',

'N/A')

I am asusming that this OR condition could be a problem. Can anyone please tell me how to resolve this type of if or statement issues?

Thank you. I would really appreciate your reply.

[lironbaram]

try this one

if(wildmatch(Country,'United States of America','China','Taiwan','Germany (Federal Republic of)', 'Netherlands')>0 AND match(Status,'Allowed','Granted')>0

and (InventionValue<3 or wildmatch(Tag , '*Apple_Tabled*')>0 or (Company='Apple' and match(IFSCORE,'1','2')>0)), 'Tabled',

'N/A')