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.