Posted to microsoft.public.excel.misc
|
|
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.
|