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?
|