Transportation Rate Schedule for Bins.xlsx
Hello,
This is my first post, so please excuse my poor use of Excel Jargon.
I'm trying to find a formula to calculate an combine different transportation rates based on the total number of bins to be shipped.
Our trucks carry two bins, so we give a discount for picking up the second bin.
Looking at the attached sheet, can someone help me with a formula that can sum in cell H5 based on the following criteria:
One Bin - C5*D5=H5
Two Bins - C5*(D5+E5)=H5
Three Bins - C5*(D5*2+E5)=H5
Four Bins - C5*(D5*2+E5*2)=H5
Five Bins - C5*(D5*3+E5*2)=H5
Etc.
Etc.
Etc.
Thank you!
Bookmarks