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!