Setup a Formula to Calculate Carriage Costs based on List

Closed - This job posting has been filled and work has been completed.
Web, Mobile & Software Dev Other - Software Development Posted 2 years ago

Fixed Price

Delivery by July 31, 2014




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.

About the Client

(4.97) 8 reviews

United Kingdom
Kent 02:03 AM

16 Jobs Posted
75% Hire Rate, 1 Open Job

$4,449 Total Spent
13 Hires, 4 Active

$8.69/hr Avg Hourly Rate Paid
454 Hours

Member Since Dec 9, 2013