H
hoshour
How do I do this in Excel 2003?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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)
"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.
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!*
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)
don't want MROUND, but FLOOR.
=FLOOR(A2,5)