Setup a Formula to Calculate Carriage Costs based on List

Closed - This job posting has been filled and work has been completed.

Job Description

I need a formula that works out the carriage cost of certain price breaks of products

So the quantities would be:

100 - 250 - 500 - 1000 - 2500

I have a column that tells me how many products fit in a carton.

I then have a list of the carton carriage rate.
I pthen have a list of the pallet carriage rate

At some point the cartons fit onto a pallet and extra cartons are charged separately.

So I need the formula creating that works out what the total carriage cost will be for that price break.

I'll give you a link to the google sheet that you can work on when I accept a freelancer.