S
Siper1
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
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