"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?