May 21 2018
08:05 PM
- last edited on
Jul 31 2018
08:12 AM
by
TechCommunityAP
May 21 2018
08:05 PM
- last edited on
Jul 31 2018
08:12 AM
by
TechCommunityAP
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!
May 21 2018 08:53 PM
Gavin,
"shipping rates" triggered me to this recent playlist from Mike Girvin:
https://www.youtube.com/playlist?list=PLrRPvpgDmw0lPFzYjORi-pIgVrunNQXqc
Hope it helps.