Thread: Rounding
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
McGowan McGowan is offline
external usenet poster
 
Posts: 4
Default Rounding

Thanks Bob, I appreciate your Help!

"Bob Umlas, Excel MVP" wrote:

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