The Punters Lounge - The World's Best Betting Forum - View Single Post

ArtMaster · 29-04-2008, 16:57

Hello,

Is there an easy way to round a cell to the nearest 0.5?

Say I have 3.18, 2.33, 1.52, 1.68 is there a formula I can use to round them all to 3.2, 2.35, 1.5, 1.7?

Thanks

29-04-2008, 16:57	#1 (permalink)
ArtMaster Senior Punter Join Date: 07 Aug 2006 Location: Brisbane Age: 25 Posts: 164	Quick Excel Query Hello, Is there an easy way to round a cell to the nearest 0.5? Say I have 3.18, 2.33, 1.52, 1.68 is there a formula I can use to round them all to 3.2, 2.35, 1.5, 1.7? Thanks