Formula problem with decimal
 

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

Formula problem with decimal
 

Round the Multiplication like:

=ROUND(Cell1*Cell2,2)

--
HTH

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


Replace @mailinator.com with @tiscali.co.uk


"Gator" wrote in message
...
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

Formula problem with decimal
 

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

--
Biff
Microsoft Excel MVP


"Gator" wrote in message
...
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