Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
could anyone help me out with a formula similar to MROUND but that always
rounds down? for example I have in cell A1 5.99 and I want to round this to the nearest LOWER 1/8th. So as where MROUND would give me 6.00, i need this formula to round to 5.875. any help is greatly appreciated! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Maybe this...
=FLOOR(A1,0.125) -- Biff Microsoft Excel MVP "Xhawk57" wrote in message ... could anyone help me out with a formula similar to MROUND but that always rounds down? for example I have in cell A1 5.99 and I want to round this to the nearest LOWER 1/8th. So as where MROUND would give me 6.00, i need this formula to round to 5.875. any help is greatly appreciated! |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
But with the warning that with Biff's formula you'll get a #NUM! error if A1
is negative. =FLOOR(A1,0.125*SIGN(A1)) will work, if rounding "down" is regarded as towards zero. =IF(A10,FLOOR(A1,0.125),CEILING(A1,-0.125)) if "down" is towards minus infinity. -- David Biddulph "T. Valko" wrote in message ... Maybe this... =FLOOR(A1,0.125) -- Biff Microsoft Excel MVP "Xhawk57" wrote in message ... could anyone help me out with a formula similar to MROUND but that always rounds down? for example I have in cell A1 5.99 and I want to round this to the nearest LOWER 1/8th. So as where MROUND would give me 6.00, i need this formula to round to 5.875. any help is greatly appreciated! |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
On Tue, 26 Jan 2010 18:25:01 -0800, Xhawk57
wrote: could anyone help me out with a formula similar to MROUND but that always rounds down? for example I have in cell A1 5.99 and I want to round this to the nearest LOWER 1/8th. So as where MROUND would give me 6.00, i need this formula to round to 5.875. any help is greatly appreciated! If by "ROUNDDOWN" you mean round closer to zero, then: =ROUNDDOWN(A1*8,0)/8 --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I round numbers to the nearest multiple of 10 or 5? | Excel Worksheet Functions | |||
How can I Round up to the nearest .25 | Excel Discussion (Misc queries) | |||
How can I Round up to the nearest .25 | Excel Discussion (Misc queries) | |||
Round to nearest multiple | Excel Discussion (Misc queries) | |||
Can you round up numbers to the nearest multiple of ten? | Excel Worksheet Functions |