MROUND function. Getting the following error: #NAME?

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

Regard,
KL


"masoud" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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 Tools>Add-ins, tick the box next to "Analysis ToolPack" and press OK.

Regard,
KL


"masoud" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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

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 Tools>Add-ins, tick the box next to "Analysis ToolPack" and press OK.

Regard,
KL


"masoud" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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