ashmott
Registered User

Hi there.
Need to know how to lay down following exel shipping calculator:
Have two shipper's exel price list and need to know whom of which is most competitve in terms of chargeable weight taking into account the following criteria:

Shipment Example:

Gross Weight: 300 kg.
Volume: 3 cubic meters

Trucking chargeable parameter: 1 cubic meter = 250 Kg

Chargeable Weight: (3 cubic meters X 250 Kg) =

750 Kg > 300 Kg

Once established charcheable weight, it must multiply by its related price per Kg within two shipping Exel files and display the
most competitive one.

Clear ?

Thanks
Toby