Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can MROUND be used to always round down? | Excel Discussion (Misc queries) | |||
MROUND | Excel Discussion (Misc queries) | |||
MRound | Excel Discussion (Misc queries) | |||
MRound and Roundup | Excel Worksheet Functions | |||
Mround | Excel Discussion (Misc queries) |