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

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 toolsadd ins and select Analysis
ToolPak and follow the instructions


--
Regards,

Peo Sjoblom


"Rob Connolly" <Rob wrote in message
...
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

Tools=add-ins check Analysis Toolpak

"Rob Connolly" wrote:

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

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

--
HTH...

Jim Thomlinson


"Rob Connolly" wrote:

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

On Aug 3, 2:54 pm, Rob Connolly <Rob
wrote:
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.