Help with rounding formulas
 

I am trying to round a whole number to the nearest hundred ex 8490 needs
to be rounded to 8500. How do I do this?




--
TriciaF

Help with rounding formulas
 

=mround(a1,100)
if the analysis toolpak is loaded (tools|addins)



TriciaF wrote:

I am trying to round a whole number to the nearest hundred ex 8490 needs
to be rounded to 8500. How do I do this?

--
TriciaF

--

Dave Peterson

Help with rounding formulas
 

On Tue, 5 Sep 2006 21:16:17 +0100, TriciaF
wrote:


I am trying to round a whole number to the nearest hundred ex 8490 needs
to be rounded to 8500. How do I do this?


=ROUND(A1,-2)


--ron