Value compare based on The True or false

[THENNA_41]

I am trying to compare values based on the two columns . If DCL BOM column has DCL value at the same time, DCL column has value  its return True and  DCL has NDCL and DCL column has a blank, its also return True . for false condition  

DCL Bom column has a DCL  value and the DCL column have a  blanks are false and  if the DCL BOM column has NDCL  a value,  DCL column also have  its false 

DCL Bom         DCL 

DCL               DCM PM                    --  true 

NDCL                                               -- true 

DCL                                                 -- Fasle 

NDCL             DCMPM                    --Fasle 

Looking for support thanks in advance

[FreemanZ · Accepted solution]

try to add a new column with the code below:

Column =

IF(

    OR([DCL Bom]="DCL"&&[DCL]<>BLANK(), [DCL Bom]="NDCL"&&[DCL]=BLANK()),

    TRUE,

    FALSE  

)

i tried and it worked like this:

[THENNA_41]

@FreemanZ  Thank you for your reply .DCL column  will be differ based on the data its not a static value