View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

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