Round Down to the nearest multiple

X

Xhawk57

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!
 
R

Ron Rosenfeld

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!
Click to expand...

If by "ROUNDDOWN" you mean round closer to zero, then:

=ROUNDDOWN(A1*8,0)/8

--ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Round formula 1
Round time up to nearest :15 2
rounding up to nearest specified whole number 1
Round Number to Nearest 50 3
Round to nearest multiple 3
Rounding up or down decimals to the nearest 5 2
Rounding numbers 5
MROUND 4

Top