How to combine these?

[Jim]

Hello,
I'm using Excel 2003 and I need a formula that will do the following:
=Sum(a1*$a$2) and then take that value and do =MRound(total from formula 1,
05) Does anyone know how to combine these?
Thanks for any help.

Jim

 

[Dave Peterson]

Maybe...

=mround(sum(a1*$a$2),5)

But =sum() isn't helping here. This should work just as well.

=mround(a1*$a$2,5)

 

[Peo Sjoblom]

=MROUND(A1*$A$2,0.5)

no need to use the SUM in this case


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Jim]

Thanks, mround(a1*$a$2,0.5) worked great.

Maybe...

=mround(sum(a1*$a$2),5)

But =sum() isn't helping here. This should work just as well.

=mround(a1*$a$2,5)