Quick Excel Query - The Punters Lounge

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

Smokin Joe · 29-04-2008, 17:27

I presume you mean 0.05, and not 0.5?

A workaround solution is:
=ROUND(YOURVALUE/0.05,0)*0.05

The proper way of doing it uses the function MROUND, but I think you need an add in pack to use that formula.

ArtMaster · 29-04-2008, 18:19

Awesome! Thanks a lot mate, yep meant 0.05 - works a treat

29-04-2008, 16:57	#1 (permalink)
ArtMaster Senior Punter Join Date: 07 Aug 2006 Location: Brisbane Age: 24 Posts: 163	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

29-04-2008, 17:27	#2 (permalink)
Smokin Joe Newbie Punter Join Date: 25 Feb 2008 Posts: 25	Re: Quick Excel Query I presume you mean 0.05, and not 0.5? A workaround solution is: =ROUND(YOURVALUE/0.05,0)*0.05 The proper way of doing it uses the function MROUND, but I think you need an add in pack to use that formula.

29-04-2008, 18:19	#3 (permalink)
ArtMaster Senior Punter Join Date: 07 Aug 2006 Location: Brisbane Age: 24 Posts: 163	Re: Quick Excel Query Awesome! Thanks a lot mate, yep meant 0.05 - works a treat

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Football Betting Tips	Australian Free Bet Offers HOT	Free Bets HOT	Odds Comparison	BetDevil
Soccer Punter	Free Betting Tips	Free Online Bets	BetPortfolio	SFstats
TotalFootballPredict	1Picks	Footy Yield

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)