Hello,
I have multiple prices in a lookup and I want the pricing returned as a curve and not a step at the different price breaks. Is that possible in Excel?
So prices of 1 @ $50, 10 @ $35, 20 @ $20, 10 @ $5. If my qty is 6, I need it to look at $50 and the $35 and create a curve.
Thanks for the help.
I have multiple prices in a lookup and I want the pricing returned as a curve and not a step at the different price breaks. Is that possible in Excel?
So prices of 1 @ $50, 10 @ $35, 20 @ $20, 10 @ $5. If my qty is 6, I need it to look at $50 and the $35 and create a curve.
Thanks for the help.