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.