excel rounding
 

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.

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.

excel rounding
 

If you have the analysis toolpack installed you can use this formula
=MROUND(A2-A1,0.25)

otherwise you will have to use something like this one
=ROUND(4*(A2-A1),0)/4

"craig phila" wrote:

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.

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.

excel rounding
 

thanx. that'll do it
--
craig phila


"Sloth" wrote:

If you have the analysis toolpack installed you can use this formula
=MROUND(A2-A1,0.25)

otherwise you will have to use something like this one
=ROUND(4*(A2-A1),0)/4

"craig phila" wrote:

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.