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 monthPrice per UnitFirst 0 – 500$0.75Next 501 – 2,500$0.70Next 2,501 – 10,000$0.65Next 10,001 – 25,000$0.60Next 25,001 – 50,000$0.55Next 50,001 – 100,000$0.50Next 100,001 – 250,000$0.45Next 250,001+$0.40

If I have 27,000 units, the total price would be $16,748.05.

Any help would be very much appreciated!

​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 monthPrice per UnitFirst 0 – 500$0.75Next 501 – 2,500$0.70Next 2,501 – 10,000$0.65Next 10,001 – 25,000$0.60Next 25,001 – 50,000$0.55Next 50,001 – 100,000$0.50Next 100,001 – 250,000$0.45Next 250,001+$0.40 If I have 27,000 units, the total price would be $16,748.05.Any help would be very much appreciated!  Read More

​