ROUND function

[Jason O]

Hi,

Just a quick question. I was wanting to round cells to the nearest 25 (i.e
0,25,50,75 etc..), and thought that the ROUND function may incorporate the
ability to specify the 'nearest factor' in this case, 25. It wouldn't seem
that it can. What I used in the end to give cell A7 rounded to the nearest
25 was:

=ROUND((A7/25),0)*25

Is this how to best do it? And then just replace the 25 for any other
integer which you want to round to? It just seemed a bit long-winded.

Cheers

Jason
____

 

[Jim Gordon MVP]

Hi Jason,

I think MROUND does what you are asking for.

-Jim

 

[JE McGimpsey]

Hi,

Just a quick question. I was wanting to round cells to the nearest 25 (i.e
0,25,50,75 etc..), and thought that the ROUND function may incorporate the
ability to specify the 'nearest factor' in this case, 25. It wouldn't seem
that it can. What I used in the end to give cell A7 rounded to the nearest
25 was:

=ROUND((A7/25),0)*25

Is this how to best do it? And then just replace the 25 for any other
integer which you want to round to? It just seemed a bit long-winded.

That's the best way, IMO, though the internal parens aren't strictly
necessary. Jim's given you another: MROUND, though that needs the
Analysis Toolpak Add-in (Tools/Add-ins..., check the appropriate
checkbox). As long as anyone who uses your spreadsheet has the ATP,
MROUND is easier, but there are some workplaces where the ATP isn't
installed.