Re: Why doesn't MROUND work?
 From: "Niek Otten" <nicolaus@xxxxxxxxx>
 Date: Sun, 19 Jun 2005 10:55:23 +0200
MROUND is an Analysis Toolpak function,
Tools>Addins, check Analysis Toolpak (and Analysis ToolpakVBA)

Kind Regards,
Niek Otten
Microsoft MVP  Excel
<joeu2004@xxxxxxxxxxx> wrote in message
news:1119163971.094177.92250@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> MROUND does not seem work at all in Excel 2003
> (11.6355.6360) SP1. I am using MS Win XP Pro SP2.
> When I put =MROUND(...) into a cell, I get a #NAME?
> error.
>
> The irony is: MROUND worked for me in previous
> Excel revisions, even though it was not in the
> catalog of commands. Now it appears in the catalog
> of commands, but it does not work. Go figure!
>
> Can anyone explain why MROUND does not work  or
> how to get it to work?
>
> Is there an alternative function that performs the
> same computation, namely: round to a multiple of
> a specified number?
>
> Yes, I can compute this myself, namely: MROUND(N,M)
> = M*ROUND(N/M,0). But MROUND is more convenient.
>
.
 FollowUps:
 Re: Why doesn't MROUND work?
 From: joeu2004
 Re: Why doesn't MROUND work?
 References:
 Why doesn't MROUND work?
 From: joeu2004
 Why doesn't MROUND work?
 Prev by Date: RE: How do I protect only formulas in Excel?
 Next by Date: HELP! Brand new user to excel and having problems...
 Previous by thread: Why doesn't MROUND work?
 Next by thread: Re: Why doesn't MROUND work?
 Index(es):
Relevant Pages
