Formula for tiered pricing based on an average

[fatcow_81]

I need to write a formula that would show tiered pricing based on an average production to determine the total price per kilo and then multiple that by total trees to determine my total cost. I have about 50 of these to calculate and need an efficient way of setting up my spreadsheet and formula to achieve this.


I use Office 365. Any help would be greatly appreciated.

[JohnTopley]

See attached

=SUMPRODUCT(($F$16>=$B$12:$B$14)*($F$16-$B$12:$B$14),$E$12:$E$14)*$F$17

Background info on this ....

http://www.mcgimpsey.com/excel/variablerate.html