Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can MROUND be used to always round down?
I would like to be able to round a number to 0.25 but always rounding down (I
also need to be able to do the same thing, but always round up) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can MROUND be used to always round down?
=FLOOR(I1,0.25)
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "m.collett" wrote in message ... I would like to be able to round a number to 0.25 but always rounding down (I also need to be able to do the same thing, but always round up) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can MROUND be used to always round down?
On Mon, 19 Feb 2007 08:25:36 -0800, m.collett
wrote: I would like to be able to round a number to 0.25 but always rounding down (I also need to be able to do the same thing, but always round up) Lots of ways: =ROUNDDOWN(A1/0.25,0)*0.25 =ROUNDUP(A1/0.25,0)*0.25 =CEILING(A1,0.25) =FLOOR(A1,0.25) --ron |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can MROUND be used to always round down?
maybe you could use:
=floor(a1,.25) m.collett wrote: I would like to be able to round a number to 0.25 but always rounding down (I also need to be able to do the same thing, but always round up) -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can MROUND be used to always round down?
Thanks for all replies - I'll head off and experiment.
M "Ron Rosenfeld" wrote: On Mon, 19 Feb 2007 08:25:36 -0800, m.collett wrote: I would like to be able to round a number to 0.25 but always rounding down (I also need to be able to do the same thing, but always round up) Lots of ways: =ROUNDDOWN(A1/0.25,0)*0.25 =ROUNDUP(A1/0.25,0)*0.25 =CEILING(A1,0.25) =FLOOR(A1,0.25) --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MROUND | Excel Discussion (Misc queries) | |||
MRound | Excel Discussion (Misc queries) | |||
MRound and Roundup | Excel Worksheet Functions | |||
Why doesn't MROUND work? | Excel Discussion (Misc queries) | |||
Mround | Excel Discussion (Misc queries) |