Rounding

[McGowan]

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

 

[Bob Umlas, Excel MVP]

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

 

[Jim Thomlinson]

Check out this link...

http://www.mcgimpsey.com/excel/pennyoff.html

 

[Stephen]

Formatting a cell only changes what is displayed. It doesn't alter the value
in the cell. You should write your individual formulas to round as required:
=ROUND(your_formula,2)

Or write the SUM formula to do this to each before adding them:
=SUM(ROUND(your_range,2))

 

[McGowan]

Thanks Bob, I appreciate your Help!

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

 

[McGowan]

Thanks for your reply!

Check out this link...

http://www.mcgimpsey.com/excel/pennyoff.html

 

[McGowan]

Thanks Stephen!

Formatting a cell only changes what is displayed. It doesn't alter the value
in the cell. You should write your individual formulas to round as required:
=ROUND(your_formula,2)

Or write the SUM formula to do this to each before adding them:
=SUM(ROUND(your_range,2))