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.