Shipping Rate Calculation using WEIGHT

Edit: Spreadsheet attatched

Edit: Version, 2001 (build 12430.20184) if that helps?

Basically, I need to figure out the costs of a SKU by its weight. Every 100gs is 0.544, every 100gs added a fee of 0.544 would be added, example 200gs would be 1.088 and so on. I could easily manually do this for this one sheet, issue is I have approx 8 sheets to do, so I want a quick way of doing this and I can't seem to figure this out.

Any help would be greatly received

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

Administrative note
Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
Thanks

Thank you for the advice