Hi, I need a formula that would compute the incremental price based on staggered pricing structure.
For example:
1-100 $5
101-500 $4
501-1000 $3
1001+ $2
Such that if you have say 200 units, the total would be (100*5) + (100*4) = $900
Likewise, if you had 600 units, the total...