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.