software

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

quot;Dianequot; gt; wrote in message
...
gt; When multiplying numbers with different digits after the decimals, is
gt; there a
gt; 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)

quot;Dianequot; wrote:

gt; When multiplying numbers with different digits after the decimals, is there a
gt; 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.

quot;Niek Ottenquot; wrote:

gt; =ROUND(A1,2)*ROUND(B1,2)
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;Dianequot; gt; wrote in message
gt; ...
gt; gt; When multiplying numbers with different digits after the decimals, is
gt; gt; there a
gt; gt; formula that can be used to multiply only 2 digits after the decimal?
gt;
gt;
gt;

A1=1.234
A2=5.678

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