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?

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

--
Kind regards,

Niek Otten

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

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)

"Diane" wrote:

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?

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

this might be more appropriate depending your application.

"Niek Otten" wrote:

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

--
Kind regards,

Niek Otten

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

A1=1.234
A2=5.678

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