Forum Discussion
work out cost of shipment
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 ...
James_S1989 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.