Monthly
Volume Price per Unit
Tier 1 100,000 $0.400
Tier 2 200,000 $0.300
Tier 3 300,000 $0.200


What formula would I use to determine what the average price would be based
upon entering a specific number in a cell, such as 250,000?

I want to create a pricing calculator, in which I can enter the volume for
the month and it creates what the price is based upon the previously stated
tiers.

Many thanks,

Matt