So I am looking for a faster way to do this. Imagine you have a product, that product could could come in quantity of 1-100, and if that product is ProductA then multiply the quantity by 2 to get the number of boxes. If ProductB then multiply the quantity by 1 to determine # of boxes. Then again, create another adjacent cell to determine how many pallets. If Product A,B,... then multiply by 2 to determine # of pallets, but if Product C or D then multiply by 4.
Goal is to determineScreenshot 2022-05-17 155234.png the number of boxes or pallets based on what the product is and the quantity.
Bookmarks