Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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',
''
)
)
)
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.