Thread: excel rounding
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 620
Default excel rounding

=mround(A2-A1,.25)
but you'll need to make sure that you've got the Analysis ToolPak add-in
enabled.
--
David Biddulph

"craig phila" <lotus wrote in message
...
in lotus, if i wanted to round to a quarter unit, i'd write
@roundm(A2-A1,.25). how do i achieve the same effect in excel 2003? the
info in A1 and A2 could be numbers, times, etc.