Thread: excel rounding
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
lotus lover lotus lover is offline
external usenet poster
 
Posts: 6
Default excel rounding

thanx. that'll work.
--
craig phila


"David Biddulph" wrote:

=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.