View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default MROUND error showing

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.