Reducing digits when multiplying
=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?
|