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.
|