View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 618
Default rounding function

"Gary''s Student" wrote in message
...
"rcc" wrote:

I'm trying to round numbers to the nearest 10, but when I enter something
like =mround(16,10) into the cell, I just get a formula error. Do I have
some kind of seeting not working somewhere, or something?


Make sure the Analysis ToolPak addin is loaded


Or an alternative is
=ROUND(16,-1)
--
David Biddulph