Forum Discussion
LaurenD760
Aug 21, 2024Copper Contributor
Help with Tiered Pricing Formula
Hello! I'm looking for assistance with a creating a formula that takes a single value and calculates the cost based on tiered pricing. Here is the pricing structure: Units per month ...
SergeiBaklan
Aug 21, 2024Diamond Contributor
For such setup
it could be
=LET(
units, $I3,
n, XMATCH(units, to, 1),
costBefore, IFERROR(SUM((TAKE(to,n-1)-TAKE(from,n-1)+1)*TAKE(price,n-1)),0),
costRange, (units-INDEX(from,n)+1)*INDEX(price,n),
costBefore+costRange )