View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default MROUND error showing

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.