Formula problem with decimal

[Gator]

I am multiplying two cells to get a result in a third cell. the result comes
out to be 18.525. I format the decimal to show only two numbers, like 18.53
but when I multiply this number to another number it is multiplying like
18.525. How can I make it multiply like 18.53?
thanks

 

[Sandy Mann]

Round the Multiplication like:

=ROUND(Cell1*Cell2,2)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[T. Valko]

Do the rounding within the formula not by formatting the number of decimal
places.

A1 = 10.183
B1 = 5.572

A1*B1 = 56.73968

=ROUND(A1*B1,2)

=56.74