You MUST use the Analysis toolpak. Did you turn it "on"?
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Julie P." wrote in message
...
"Anne Troy" wrote in message
news:357e3$42b745a9$466eb880$24595@allthenewsgroup s.com...
Go to Tools--Addins and turn on the Analysis Toolpak (if it's not
already).
Then use the MROUND function, thusly:
=MROUND(A1,100)

Hope it helps!


Thanks Anne! But when I do this, I get an error:

"#NAME?"

Did I do something wrong?