I figured that Add-In had to already be checked given, according to the OP's
original posting, that he used the MROUND function originally and had gotten
a numerical result from having done so.

Rick


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Analysis ToolPak, Rick?
--
David Biddulph

"Rick Rothstein (MVP - VB)" wrote in
message ...
When I tried this I got only "#NAME?"

I'm not sure why you would have gotten that error... the formula I posted
works fine in XL2003 and XL2007.
...