MROUND function. Getting the following error: #NAME?
 

Hello,
i am trying to round numbers to a a multiple of 5. i am trying to use the
MROUND function. But i am having the following error : #NAME? Formula
contains unrecognised text

menu ToolsAdd-ins, tick the box next to "Analysis ToolPack" and press OK.

Regard,
KL


"masoud" wrote in message
...
Hello,
i am trying to round numbers to a a multiple of 5. i am trying to use the
MROUND function. But i am having the following error : #NAME? Formula
contains unrecognised text

you could also substutute MROUND with a standard function, e.g.:

=MROUND(A1,50)

equals

=ROUND(A1/50,0)*50

Regards,
KL

"masoud" wrote in message
...
Hello,
i am trying to round numbers to a a multiple of 5. i am trying to use the
MROUND function. But i am having the following error : #NAME? Formula
contains unrecognised text