MROUND function

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
 
C

Chip Pearson

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
 
G

Guest

Chip,

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

:)
Sherry
 
Top