This content has been marked as final. Show 3 replies
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.