ROUND to nearest 5

[Jeff Kocsis]

I know I've done this before in Excel. I want to round to
the nearest 5.

So 462 = 460
and 463 = 465

I tried round(A1,-1.5) and obviously that doesn't work.
Any thoughts? I was thinking about a formula to round down
and then round up, add and divide by 2, but that seems
like it is too complicated for something relatively simple.
Thanks,
Jeff

 

[Chip Pearson]

Jeff,

Use the MROUND function. For example,

=MROUND(A1,5)

This is part of the Analysis Tool Pack add-in, so this add-in must be loaded
in order to use the function.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Dave R.]

=+ROUND(A1/5,0)*5

 

[Guest]

=MROUND(A1, 5) (analysis toolpak)

 

[Jeff Kocsis]

Thanks, that worked like a champ!!!

And thanks for the quick reply!