rounding function
 

I'm trying to round numbers to the nearest 10, but when I enter something
like =mround(16,10) into the cell, I just get a formula error. Do I have
some kind of seeting not working somewhere, or something?

Thanks.

rounding function
 

From the mround function help:

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

How?

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then
click OK.
If necessary, follow the instructions in the setup program.


"rcc" wrote:

I'm trying to round numbers to the nearest 10, but when I enter something
like =mround(16,10) into the cell, I just get a formula error. Do I have
some kind of seeting not working somewhere, or something?

Thanks.

rounding function
 

Make sure the Analysis ToolPak addin is loaded
--
Gary's Student


"rcc" wrote:

I'm trying to round numbers to the nearest 10, but when I enter something
like =mround(16,10) into the cell, I just get a formula error. Do I have
some kind of seeting not working somewhere, or something?

Thanks.

rounding function
 

Thanks, easy enough.

"rcc" wrote:

I'm trying to round numbers to the nearest 10, but when I enter something
like =mround(16,10) into the cell, I just get a formula error. Do I have
some kind of seeting not working somewhere, or something?

Thanks.

rounding function
 

Try,
=MROUND(16,"10")
Or with the value in A1,
=MROUND(A1,"10")
Regards,
Alan.
"rcc" wrote in message
...
I'm trying to round numbers to the nearest 10, but when I enter something
like =mround(16,10) into the cell, I just get a formula error. Do I have
some kind of seeting not working somewhere, or something?

Thanks.

rounding function
 

"Gary''s Student" wrote in message
...
"rcc" wrote:

I'm trying to round numbers to the nearest 10, but when I enter something
like =mround(16,10) into the cell, I just get a formula error. Do I have
some kind of seeting not working somewhere, or something?

Make sure the Analysis ToolPak addin is loaded

Or an alternative is
=ROUND(16,-1)
--
David Biddulph