Round Down to the nearest multiple
 

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!

Round Down to the nearest multiple
 

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!

Round Down to the nearest multiple
 

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!

Round Down to the nearest multiple
 

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