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

How do I do this in Excel 2003?

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

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


"hoshour" wrote:

How do I do this in Excel 2003?

Rounding column of #s down so each cell is a multiple of 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.
--
David Biddulph

"hoshour" wrote in message
...
How do I do this in Excel 2003?

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

Thanks. I'll try it again.

"Luke M" wrote:

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


"hoshour" wrote:

How do I do this in Excel 2003?

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

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

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
=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.
--
David Biddulph

"hoshour" wrote in message
...
How do I do this in Excel 2003?