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

A

ALCID

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

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
 
F

Frank Kabel

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

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
Click to expand...


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
 
Top