excel rounding

C

craig phila

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

David Biddulph

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