| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel won't stop rounding numbers. Please help | Excel Discussion (Misc queries) | |||
| Excel file with hyperlinks takes a long time to open over the network | Links and Linking in Excel | |||
| How do I stop excel from rounding numbers? | Excel Discussion (Misc queries) | |||
| How do I record (.468) time in Excel without it rounding to .5? | Excel Discussion (Misc queries) | |||
Linear Mode
