View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Simple multiplication of 2 cells = wrong product

If D29 is exactly 32.33, then you'd get a product of 17.68 if B29 is
0.546860501082586, but if you've formatted the cell to display as 2 decimal
places it would look like 0.55. If you get unexpected results it's always
worth displaying more decimal places.
--
David Biddulph

"chrisp" wrote in message
...
Yes, the value of B29 is 0.55 and D29 is $32.33 the result is a value in
E29
of $17.68


"Ed Cones" wrote:

Can you give an example of the numbers in B29 and D29?


"chrisp" wrote:

All I need is the product of two cells in a third cell. I entered an
equation =B29*D29 in the third cell but the product is wrong. Checked
it
with calculator and another application. One of the two cells being
multiplied is formatted for currency, but other instances of the same
calculations are correct. Is there a glitch in excel 2003?