Thread
:
Help with rounding formulas
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson
external usenet poster
Posts: 35,218
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
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson