Rounding column of #s down so each cell is a multiple of 5

L

Luke M

Repost of question:
"Rounding column of #s down so each cell is a multiple of 5"

In the future, try to use the body of a post for your question, as titles of
posts get cut-off.
Something similar to this should work.
=FLOOR(A2,5)
 
D

David Biddulph

=MROUND(A2,5), and copy down.
and next time please ask your question in the body of the message, not just
in the subject line.

If you have problems with MROUND, look it up in Excel help.
 
H

hoshour

Thanks. I'll try it again.

Luke M said:
Repost of question:
"Rounding column of #s down so each cell is a multiple of 5"

In the future, try to use the body of a post for your question, as titles of
posts get cut-off.
Something similar to this should work.
=FLOOR(A2,5)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*
Click to expand...
 
D

David Biddulph

Reading it again (having not read your subject line fully), I see that you
don't want MROUND, but FLOOR.
=FLOOR(A2,5)
 

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

rounding a number up to a certain ending digit 6
How to make repeating drop-down lists? 2
Drop down list control value in vba 2
Merging from an Excel file with graphics 1
Embed the same Excel multiple times 0
Cell data entering slow! 0
Alternate Rounding Up & Down of .50 in a column 5
How to round down a value to the inferior multiple of 5 3

Top