Calculating Value Based on Multiple Criteria

Copper Contributor

I have a sheet that contains a master product price list. I'm trying to design another sheet within the same workbook utilizing a formula that will reference data in the price list to calculate per-unit pricing for customized products. There are a number of static variables with customized products (i.e. logo digitization, engraving fee, etc.) that are very straight-forward. The challenge is the data than varies such as tiered bulk pricing and tiered shipping rates based on quantity and product subtotal, respectively. Ideally, there's a single formula that can reference the appropriate data and perform all the calculations so that the only thing I need to change from cell to cell in the second sheet is the product price being referenced, but I'm stuck. Any solutions or examples of solutions are extremely appreciated. Many thanks ahead!

1 Reply

Gavin,

 

"shipping rates" triggered me to this recent playlist from Mike Girvin:

https://www.youtube.com/playlist?list=PLrRPvpgDmw0lPFzYjORi-pIgVrunNQXqc

 

Hope it helps.