IF statement doesnt return all

[Anonymous]

Hi,

can someone please tell me what's wrong with this statement.

If(BRANCH ='DOME' OR 'MAKOLA' OR  'AVENOR' OR  'MUUS','GREATER ACCRA',IF(BRANCH = 'SWEDRU','CENTRAL',IF(BRANCH ='KUMASI','ASHANTI',NULL()))) as Region;

when i select GREATER ACCRA from Region it only shows DOME and not the rest MAKOLA, AVENOR and MUUS.

Thanks

[rajni_batra · Accepted solution]

if statement does not work like this

use

if (Match(Branch,'DOME','MAKOLA' ,'AVENOR','MUUS'),'GREATER ACCRA',

  if(Branch='SWEDRU','CENTRAL',

   IF(BRANCH ='KUMASI','ASHANTI',Null()))) as Region

[nilesh_gangurde]

IF(wildmatch(BRANCH ,'DOME' , 'MAKOLA' ,  'AVENOR' , 'MUUS') , 'GREATER ACCRA',

IF(wildmatch(BRANCH = 'SWEDRU') , 'CENTRAL',

IF(wildmatch(BRANCH ,'KUMASI') , 'ASHANTI',

NULL()))) as Region

Regards,

Nilesh Gangurde

[Anonymous]

Thanks a lot