How can set up Excel to calculate total pricing based on multiple pricing &
usage tiers:

Usage - Price
0-50,000 = $.60
50,001 - 150,000 = $.50
150,001+ = $.40

Example:

250,000 units

Need to automate the following:

50,000 = $30,000
50,001 - 150,000 = $50,000
150,001+ = $40,000

Total Due = $120,000