Multiple or condition in IF statement

[Anonymous]

I need to combine 3 OR condition in if statement. PowerbI only allows 2 arguments in if statement.

In the below screenshot the yellow or condition is not taken in action as only 2 arguments is allowed in if stament.

Blocked_Approved = IF(OR (vVENDOR_PURCH_ORG_AVL[CentralPurchasingBlock] = "X",vVENDOR_PURCH_ORG_AVL[PurchBlockForPurchasingOrganization]="X", vVENDOR_PURCH_ORG_AVL[BlockedForAllEnabledPurchasingOrganization] ="X"),"Blocked","Active"

How can I can take 3 or statements.

[amitchandak · Accepted solution]

@Anonymous , I think or can take only 2 arguments

Blocked_Approved = IF( (vVENDOR_PURCH_ORG_AVL[CentralPurchasingBlock] = "X" || vVENDOR_PURCH_ORG_AVL[PurchBlockForPurchasingOrganization]="X" || vVENDOR_PURCH_ORG_AVL[BlockedForAllEnabledPurchasingOrganization] ="X"),"Blocked","Active")