View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
bj
 
Posts: n/a
Default Reducing digits when multiplying

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?