MROUND
 

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?

MROUND
 

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)

"Brewer" wrote in message
...
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?

MROUND
 

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).
--
David Biddulph

"Bob Phillips" wrote in message
...
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)

"Brewer" wrote in message
...
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?