Reducing digits when multiplying

[Guest]

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]

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

 

[Guest]

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)

 

[Guest]

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

this might be more appropriate depending your application.

 

[johney]

A1=1.234
A2=5.678

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