Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MROUND
Hope someone can help but whenever I use the MROUND function the answer is
always (#NAME?). Does this even when I copy the example from the help menu. Anyone know what I'm doing wrong. Working in excel 2003 if that makes a difference. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MROUND
Hi,
MROUND requires the analysis toolpak. Tools|Addins - check the analysis toolpak Re-Enter the formula Mike "emz486" wrote: Hope someone can help but whenever I use the MROUND function the answer is always (#NAME?). Does this even when I copy the example from the help menu. Anyone know what I'm doing wrong. Working in excel 2003 if that makes a difference. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MROUND
On Wed, 22 Apr 2009 11:20:10 -0700, emz486
wrote: Hope someone can help but whenever I use the MROUND function the answer is always (#NAME?). Does this even when I copy the example from the help menu. Anyone know what I'm doing wrong. Working in excel 2003 if that makes a difference. If you read the top part of the HELP for MROUND, it will tell exactly what to do and how to do it when it returns a #NAME! error (install the Analysis toolpak) --ron |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MROUND
Do you have the Analysis ToolPak add-in installed?
That's mentioned in help for MROUND. Or, use this formula that does the exact same thing but doesn't rely on functions from the ATP: =ROUND(number/multiple,0)*multiple For example, round the value of A1 to the nearest multiple of 5: A1 = 56 =ROUND(A1/5,0)*5 Result = 55 -- Biff Microsoft Excel MVP "emz486" wrote in message ... Hope someone can help but whenever I use the MROUND function the answer is always (#NAME?). Does this even when I copy the example from the help menu. Anyone know what I'm doing wrong. Working in excel 2003 if that makes a difference. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MROUND | Excel Discussion (Misc queries) | |||
MROUND | Excel Discussion (Misc queries) | |||
MROUND | Excel Discussion (Misc queries) | |||
MRound | Excel Discussion (Misc queries) | |||
Mround | Excel Discussion (Misc queries) |