work out cost of shipment

Question

Which formula can I use in excel to work out the cost of a shipment from this data

I want be able to type in total kilos in one cell and the answer would be for example £14.70 based on 43 kilos (20 at £6.99, 20 at £0.33ea and 3 at £0.37ea)

Any help most appreciated 🙂

nikolinode · Answer

James_S1989&nbsp;Please use the solution suggested by the user below.

james_s1989 · Answer

Boom, thanks very much!

riny_van_eekelen · Answer

James_S1989&nbsp;Although you already accepted an AI generated solution, the attached workbook contains an approach without the need for nested IF functions and hard coded boundaries for each of the tiers.&nbsp;&nbsp;

Forum Discussion

work out cost of shipment

Share

Resources