View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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