3 Replies Latest reply: Sep 26, 2012 7:10 AM by Adotey Kwame RSS

    IF statement doesnt return all

    Adotey Kwame

      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