MROUND

[Brewer]

I cant make MROUND work i Excel 2003 SP3, whereas it works fine in SP2. I
have installed the Analysis ToolPak, but the function seems to have
disappeared. Can I have MROUND back in SP3?

 

[Bob Phillips]

Works fine for me with SP3, but you can do it without MROUND

=ROUND(I1/I1,0)*I2

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[David Biddulph]

I guess you intended to say =ROUND(I1/I2,0)*I2

Analysis ToolPak functions do occasionally fail mysteriously. May be worth
switching the ToolPak off and back on again (possibly with an Excel shutdown
or even a reboot between).