i have programmed a cell with the following equation: =MROUND((F9*15),50). I
am attempting to round the product of the cell reference F9 multiplied by 15
to the nearest 50. When i do this i get a cell error stating "#Name?". I am
not sure of what is happening. Any suggestions for correcting the error would
be greatly appreciated. thanks in advance.

MROUND requires the Analysis ToolPak Add-In to be active. Click
Tools/Add-Ins from Excel's menu bar and put a check mark in the appropriate
CheckBox.

--
Rick (MVP - Excel)


"tcek" wrote in message
...
i have programmed a cell with the following equation: =MROUND((F9*15),50).
I
am attempting to round the product of the cell reference F9 multiplied by
15
to the nearest 50. When i do this i get a cell error stating "#Name?". I
am
not sure of what is happening. Any suggestions for correcting the error
would
be greatly appreciated. thanks in advance.

Tools-Options-Add-Ins

and install an Analysis ToolPack


On 15 Sty, 16:28, tcek wrote:
i have programmed a cell with the following equation: =MROUND((F9*15),50). *I
am attempting to round the product of the cell reference F9 multiplied by 15
to the nearest 50. *When i do this i get a cell error stating "#Name?". I am
not sure of what is happening. Any suggestions for correcting the error would
be greatly appreciated. thanks in advance.

sorry, disregard my previous post

On 15 Sty, 16:28, tcek wrote:
i have programmed a cell with the following equation: =MROUND((F9*15),50). *I
am attempting to round the product of the cell reference F9 multiplied by 15
to the nearest 50. *When i do this i get a cell error stating "#Name?". I am
not sure of what is happening. Any suggestions for correcting the error would
be greatly appreciated. thanks in advance.

Depending on the values you're using this may be a suitable alternative that
doesn't need he ATP:

=ROUND(F9*15/50,0)*50


--
Biff
Microsoft Excel MVP


"tcek" wrote in message
...
i have programmed a cell with the following equation: =MROUND((F9*15),50).
I
am attempting to round the product of the cell reference F9 multiplied by
15
to the nearest 50. When i do this i get a cell error stating "#Name?". I
am
not sure of what is happening. Any suggestions for correcting the error
would
be greatly appreciated. thanks in advance.

sorry, disregard my previous post

Why? It was correct.


--
Biff
Microsoft Excel MVP


"Jarek Kujawa" wrote in message
...
sorry, disregard my previous post

On 15 Sty, 16:28, tcek wrote:
i have programmed a cell with the following equation: =MROUND((F9*15),50).
I
am attempting to round the product of the cell reference F9 multiplied by
15
to the nearest 50. When i do this i get a cell error stating "#Name?". I
am
not sure of what is happening. Any suggestions for correcting the error
would
be greatly appreciated. thanks in advance.

If you have trouble with any Excel function (except DATEDIF), it's always
worth looking in Excel help. Excel help for the MROUND function would have
given you the answer.
--
David Biddulph

"tcek" wrote in message
...
i have programmed a cell with the following equation: =MROUND((F9*15),50).
I
am attempting to round the product of the cell reference F9 multiplied by
15
to the nearest 50. When i do this i get a cell error stating "#Name?". I
am
not sure of what is happening. Any suggestions for correcting the error
would
be greatly appreciated. thanks in advance.

because when I uninstalled ATP to check if the solution was correct,
Excel did not show me a NAME? error
this is why I thought I was mistaken
thks

On 15 Sty, 18:13, "T. Valko" wrote:
sorry, disregard my previous post

Why? It was correct.

--
Biff
Microsoft Excel MVP

"Jarek Kujawa" wrote in message

...
sorry, disregard my previous post

On 15 Sty, 16:28, tcek wrote:



i have programmed a cell with the following equation: =MROUND((F9*15),50).
I
am attempting to round the product of the cell reference F9 multiplied by
15
to the nearest 50. When i do this i get a cell error stating "#Name?". I
am
not sure of what is happening. Any suggestions for correcting the error
would
be greatly appreciated. thanks in advance.- Ukryj cytowany tekst -

- Poka¿ cytowany tekst -