Assigning a product of a specific size to a package based dimensions

Topic Labels: Formulas
338 0
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

I am looking for some help with a formula that assigns a specific shipping box to a product based on product dimensions. I have a table for Products and Boxes.

The example dimensions of 2 product are:
Product 1 : 50cm x 40cm x 5cm
Product 2: 80cm x 60cm x 8cm

The products will be assigned to one of these two example boxes:
Box Size 1: Fits products measuring (40-60cm) x (30-50cm) x (3-6cm)
Box Size 2: Fits products measuring (60-90cm) x (0-70cm) x (7-9cm)

I am having trouble with the IF or IF/AND formulas. Any help would be appreciated.

Thank you,

0 Replies 0