Hi
Can you please help me for the following IF conditions, I tried to create it but it's a bit complex for me. Thank you so much
Multiple IF conditions to fill-up column CATEGORY
conditions are under column PACKED LOCATION, SHIPPED TO, CUSTOMER NAME AND RECEIVED LOCATION
If Packed location=NA Warehouse AND Shipped to = USA AND Customer Name = not X, then category result = "DOMESTIC"
If Packed location=NA Warehouse AND Shipped to = USA AND Customer Name = X, then category result = "INTERCOMPANY"
If Customer Name = X, the end result for Category will be "INTERCOMPANY"
If Packed location=NA Warehouse and Shipped to = non-USA AND Customer Name = not X, then category result = "INTERNATIONAL"
If (Packed location=SG Warehouse OR HK warehouse) and (Shipped to = non-USA or USA) and (Customer Name = not X) and Received location = SG Warehouse or HK Warehouse then category result = "OUT-OF-SCOPE"
Bookmarks