MROUND function. Getting the following error: #NAME?

M

masoud

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
 
K

KL

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

=MROUND(A1,50)

equals

=ROUND(A1/50,0)*50

Regards,
KL
 
Top