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

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.

29-04-2008, 17:27	#2 (permalink)
Smokin Joe Newbie Punter Join Date: 25 Feb 2008 Posts: 40	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.