Thread: MROUND
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rob Connolly Rob Connolly is offline
external usenet poster
 
Posts: 1
Default MROUND

I am trying to use the MROUND function to round to the nearest quarter a
calculated cell. The cells are properly formated to for numbers however
whenever I type in the formula "=MROUND(A1,0.25)" however rather than coming
back with the correct number it comes back with "#NAME?". Also, the formula
is changed to to lower case "=mround(A1,0.25)". Testing the formula it shows
that Excel 2003 does not recognize "MROUND".

Has anyone out there experienced this and knows how to correct it? I know
the formula is correct and I have reformated a number of times already, i
have shut the program down and then the computer and that hasn't solved it
either.

Any suggestions?

Thanks!

Rob