View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tcek tcek is offline
external usenet poster
 
Posts: 26
Default MROUND error showing

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.