View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Sloth
 
Posts: n/a
Default 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?