Rounding
 

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

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

Rounding
 

Check out this link...

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

Jim Thomlinson


"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

Rounding
 

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" wrote in message
...
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

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

Rounding
 

Thanks for your reply!

"Jim Thomlinson" wrote:

Check out this link...

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

Jim Thomlinson


"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

Rounding
 

Thanks Stephen!

"Stephen" wrote:

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" wrote in message
...
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