Formula problem with decimal

  • Thread starter Thread starter Gator
  • Start date Start date
G

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
 
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
 
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
 
Back
Top