How to combine these?

J

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
 
D

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)
 
J

Jim

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


Dave Peterson said:
Maybe...

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

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

=mround(a1*$a$2,5)
Click to expand...
 
Top