MROUND function. Getting the following error: #NAME?

[Guest]

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

 

[KL]

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

Regard,
KL

 

[KL]

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

=MROUND(A1,50)

equals

=ROUND(A1/50,0)*50

Regards,
KL