Originally Posted by DeFautT

Assuming that the courier is going to charge at .5kg intervals, try this.

actual weight - create cell for actual weight
shipping weight - =ceiling("actual weight",0.5)
Shipping cost - =SUM((("shipping weight"/0.5)-1)*5.8)+24.8

defautt