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

  • Thread starter Thread starter hoshour
  • Start date Start date
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)
 
=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.
 
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...
 
Reading it again (having not read your subject line fully), I see that you
don't want MROUND, but FLOOR.
=FLOOR(A2,5)
 
You must log in or register to reply here.

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

Alternate Rounding Up & Down of .50 in a column 5
How to round down a value to the inferior multiple of 5 3
Rounding down with a calculation 3
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Round Function 5
Rounding a group of numbers 1
Rounding Time to Nearest 5 Minutes 1
Round to multiple of 5 3

Back
Top