Try
=Ceiling(sum(),0.5)

"derrick@sugarbakers" wrote:

If I add a list of numbers using the formula =SUM( ) and the total is 32.25 -
what formula must I use to get the result that the total will be 32.50. If
the total is 40.70 the result must round up to 41.0.
The problem arises when I add metres of fabric and need to round the total
to the next half metre.