How do I correctly multiply rounded cells in Excel?
 

When I mulitply a cell that has a formula calculating a number that is then
had the ROUND function applied to it, the value using the cell is not
correct. EG. $15.37 x 650 = $9992.32. 650 is a rounding figure and the
answer should be $9990.50

Looks like the cell wasn't rounded, just formatted to 2 dec places.

Try

=ROUND(A1,2)*B1

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Kthought" wrote in message
...
When I mulitply a cell that has a formula calculating a number that is
then
had the ROUND function applied to it, the value using the cell is not
correct. EG. $15.37 x 650 = $9992.32. 650 is a rounding figure and the
answer should be $9990.50