IF condition in Qlik Table

[pradnya_avrioc]

IF(SP_5_SEC_TEST_STATUS_FAILED  = 'FAIL' OR SP_15_SEC_TEST_STATUS_FAILED  = 'FAIL', 'SECONDARY POWER ISSUE' ,
IF(PP_5_SEC_TEST_STATUS_FAILED  = 'FAIL' OR PP_15_SEC_TEST_STATUS_FAILED  = 'FAIL', 'PRIMARY POWER ISSUE'
,IF(IS_SECONDARY_POWER_SOURCE_CONNECTED_FAILED='FAIL','SEOCONDARY CONNECTION FAILED' )))

Above condition is working for "AND" I wan't it for means
User A1 is failed in 2 cases then it should those like EOCONDARY CONNECTION FAILED | PRIMARY POWER ISSUE
A2 failed in only PRIMARY POWER ISSUE like this.
Please help.

[Chanty4u]

Try this 

IF(

    (

        (SP_5_SEC_TEST_STATUS_FAILED = 'FAIL' OR SP_15_SEC_TEST_STATUS_FAILED = 'FAIL')

        AND NOT (PP_5_SEC_TEST_STATUS_FAILED = 'FAIL' OR PP_15_SEC_TEST_STATUS_FAILED = 'FAIL')

        AND NOT (IS_SECONDARY_POWER_SOURCE_CONNECTED_FAILED = 'FAIL')

    ), 

    'SECONDARY POWER ISSUE',

    IF(

        (

            NOT (SP_5_SEC_TEST_STATUS_FAILED = 'FAIL' OR SP_15_SEC_TEST_STATUS_FAILED = 'FAIL')

            AND (PP_5_SEC_TEST_STATUS_FAILED = 'FAIL' OR PP_15_SEC_TEST_STATUS_FAILED = 'FAIL')

            AND NOT (IS_SECONDARY_POWER_SOURCE_CONNECTED_FAILED = 'FAIL')

        ),

        'PRIMARY POWER ISSUE',

        IF(

            (

                NOT (SP_5_SEC_TEST_STATUS_FAILED = 'FAIL' OR SP_15_SEC_TEST_STATUS_FAILED = 'FAIL')

                AND NOT (PP_5_SEC_TEST_STATUS_FAILED = 'FAIL' OR PP_15_SEC_TEST_STATUS_FAILED = 'FAIL')

                AND (IS_SECONDARY_POWER_SOURCE_CONNECTED_FAILED = 'FAIL')

            ),

            'SECONDARY CONNECTION FAILED',

            ''

        )

    )

)

[pradnya_avrioc]

PLAYERNAME	PRIMARY	SECONDARY	SECONDARY CONNECTION	RESULT
PRADNYA	5Min |20Min |	5Min |	PASS	PRIMARY | SECONDARY

SO I have failed twice in Primary and once in Secondary so the Result column should show only Primary | Secondary and not connection likewise different scenarios.