MROUND

R

Rob Connolly

I am trying to use the MROUND function to round to the nearest quarter a
calculated cell. The cells are properly formated to for numbers however
whenever I type in the formula "=MROUND(A1,0.25)" however rather than coming
back with the correct number it comes back with "#NAME?". Also, the formula
is changed to to lower case "=mround(A1,0.25)". Testing the formula it shows
that Excel 2003 does not recognize "MROUND".

Has anyone out there experienced this and knows how to correct it? I know
the formula is correct and I have reformated a number of times already, i
have shut the program down and then the computer and that hasn't solved it
either.

Any suggestions?

Thanks!

Rob
 
P

Peo Sjoblom

You need to install the Analysis ToolPak, if you lookup MROUND in help it
clearly states that if you receive the #NAME! error you need to install it

Keep the Office/Excel CD handy, go to tools>add ins and select Analysis
ToolPak and follow the instructions
 
J

Jim Thomlinson

As an alternative to adding the Analysis Toolpack you can round to the
nearest 0.25 without using mround. This will allow you and others to round to
the nearest value without worrying about installing Addins...

=round(A1/0.25, 0) * 0.25
 
J

joeu2004

whenever I type in the formula "=MROUND(A1,0.25)" however rather than coming
back with the correct number it comes back with "#NAME?".

This is explained on the MROUND Help page. Click on Help >> Excel
Help >> Search For MROUND function >> MROUND Worksheet Function.
Also, the formula is changed to to lower case "=mround(A1,0.25)".

Upper and lower case names are not distinctive in Excel.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Round Down to the nearest multiple 3
MROUND Help 1
MROUND time 3
Round time up to nearest :15 2
MROUND 2
MRound 8
Round Number to Nearest 50 3
Rounding numbers 5

Top