View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.setup,microsoft.public.excel.worksheet.functions
GzusRox GzusRox is offline
external usenet poster
 
Posts: 1
Default Rounding numbers then doing a sum of those numbers produces incorrect result.

I have a row of numbers that gets calculated from two other rows. I
formatted this row as a number with two decimal places. I then take that row
of numbers and do a sum on it but it produces a result that is one cent off
the actual total (because I think it is adding the whole number and not the
rounded format that I chose). Is there anyway to fix this?

Thanks