View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
 
Posts: 896
Default MROUND error showing

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.