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)