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.