Thread: Rounding
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Umlas, Excel MVP Bob Umlas, Excel MVP is offline
external usenet poster
 
Posts: 320
Default Rounding

Tools/Options/Calculation/check "precision as displayed"

"McGowan" wrote:

I am summing cells that are based on the results of a formula and the result
is displayed to 2 decimal places. However the total sum doesn't match the sum
of the numbers displayed in the cells.

How do I get the sum to equal the displayed amounts in the cell versus the
sum of the unrounded cell amounts?

Thanks