To change the rounding of 0.5 to up not down

Dear All,

I have been trying for ages to get a formula where any number prefixing .5 automatically rounds up and not down as the excel standard does.

EG,

16.4999999 does show with no decimal places as 16.
16.5 does show with no decimal place as 16. But I want it to round up to 17.
and obviously 16.50000001 does indeed round to 17 anyway.

Its purley numbers that have .5 I need to go up and not down.

To those people out there with significantly more brains than me then please help.

Kind regards

Steve Wilko.