Example postage.xlsx


Hi everyone,

Just getting into excel recently for work purposes and have been struggling to come up with a formula. Info is above in the link.

Basically trying to create a shipping chart that has prices that change depending on where in the world there are and how heavy the package is.

The main part is wondering what formulae I'd use for the prices above 2kg (or any formula), as from that weight range it's an extra 2,80 per 0.5kg.

I'm absolutely lost, not sure if it's been to use a lookup or create a table, ideally I'd want a cell that reflects the right price based on the total kg and location.

Cheers!
Michael