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?