MROUND function

  • Thread starter Thread starter Sherry
  • Start date Start date
S

Sherry

I am using Excel 2003 (Office 2003). I am trying to
utilize the MROUND function, which should allow me to
round to the nearest multiple of a number. However, it
always returns an error, even if I use the example given
in Help. Does anybody know if this is a bug in the
program that I can maybe download a fix for? Or if anyone
has any other ideas in how to accomplish the task at
hand, which is to have the program round numbers up to
the nearest multiple of 25.

Thank you in advance!
Sherry
 
Sherry,

What error does MROUND return? If it returns a #NAME error, this
indicates that you don't have the Analysis Tool Pack loaded. Go
to the Tools menu, choose Add-Ins, and check the ATP.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Chip,

Thanks so much for your reply! I'm happy to report that
that did the trick!!!

:-)
Sherry
 
Back
Top