View Single Post
  #3   Report Post  
KL
 
Posts: n/a
Default

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