Dynamic Pricing Analysis
Price a batch of orders by combining three lookups with a better-of rule and a price floor: list price, customer tier, volume break and minimum markup.
What you will practise: Combine exact and approximate lookups with MAX to apply the better of two discounts and a price floor, all read from tables rather than typed.
Premium
This is a Premium exercise
Premium members can open this exercise and practise it in the spreadsheet.