drop the thousands place in a currency number

R

ram1000

I have a number 63.262 that I want to multiply another number by.
Before it multiplies I want to round off to the nearest hundredth?
63.26

I am starting with a formula from other cells and not a specific numbe
although the 63.262 is one of the variations.

Thank Yo
 
C

Christopher Tolo

You can use the round function during the muliplication.
=ROUND(67.3*0.94,2) o
=ROUND(A1*B1,2) for cell referencin
This will drop the thousand place.
 
Top