HOW DO I ROUND A NUMBER TO THE NEAREST MULTIPLE OF 5?

[Guest]

..I TRIED THIS FORMULA
=MROUND(A1,5) AND THE FPRMULA DIDN'T WORK WHERE A1 IS THE NUMBER THAT I WANT
TO ROUNG OFF

 

[Charles Maxson]

how about something like this? =ROUND(a1/5,0)*5

 

[Dave Peterson]

=mround() needs to have the analysis toolpak loaded.

Tools|addins
(see help for =mround() for more info)

Another way without the analysis toolpak.
=ROUND(A1/5,0)*5

 

[Frank Kabel]

Hi
what result did you expect?. This formula should work. Please post your
value in cell A1 and the returned value

 

[Ron Rosenfeld]

.I TRIED THIS FORMULA
=MROUND(A1,5) AND THE FPRMULA DIDN'T WORK WHERE A1 IS THE NUMBER THAT I WANT
TO ROUNG OFF

If you got the #NAME error, see HELP for MROUND. You need to install the
Analysis Tool Pak.

Or you could use this formula:

=ROUND(A1/5,0)*5


--ron