IF Statement does not work the way I want

[Anonymous]

Hello Guys,

I want to name category by following way,

IF reason code = Unexplained Shrinkage or Unexplained Overage or Previous Adjustment Error or Label/Point of Sale Error and “Tracking #” = Black then it is ACC

IF reason code = “Unexplained Shrinkage” or “Unexplained Overage” or “Previous Adjustment Error” or “Label/Point of Sale Error” and “Tracking” # <> Black then it is Hero

Please see below, it not working the way I want it. Can any please tell me why is that?

Reason = IF(AdjustmentHistory[Reason Code]="Unexplained Shrinkage" || AdjustmentHistory[Reason Code]="Previous Adjustment Error" || AdjustmentHistory[Reason Code]="Label/Point of Sale Error" && AdjustmentHistory[Tracking #] = BLANK(), "ACC", IF(AdjustmentHistory[Reason Code]="Unexplained Shrinkage" || AdjustmentHistory[Reason Code]="Previous Adjustment Error" || AdjustmentHistory[Reason Code]="Label/Point of Sale Error" && AdjustmentHistory[Tracking #] <> BLANK(),"Hero","Others"))

Reason column is not correct.

Thank you

[Phil_Seamark · Accepted solution]

HI @Anonymous

You often get unexpected results when you mix OR and AND operators in the same expression.  e.g.

A=1 or B=2 or C=3 and D=4

is not the same as 

A=1 or B=2 or (C=3 and D=4)

Note the use of the parenthesis to control the boolean logic.  I suspect some well placed brackets may help you.

[Anonymous]

@Phil_Seamark

Thank you so much. Brackets did the work.