Reducing digits when multiplying

Diane · Mar 3, 2006

When multiplying numbers with different digits after the decimals, is there a
formula that can be used to multiply only 2 digits after the decimal?

Niek Otten · Mar 3, 2006

=ROUND(A1,2)*ROUND(B1,2)

bj · Mar 3, 2006

if, for example you want to multiply a1 by b1 and only use two decimal places
of b1 you could use
=a1*round(b1,2)

Sloth · Mar 3, 2006

=ROUNDDOWN(A1,2)*ROUNDDOWN(B1,2)

this might be more appropriate depending your application.

johney · Mar 3, 2006

A1=1.234
A2=5.678

=ROOUNDDOWN(MOD(A1,1),2)*ROUNDDOWN(MOD(A2,1),2)