Rounding

  • Thread starter Thread starter McGowan
  • Start date Start date
M

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
 
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))
 
Thanks Stephen!

Stephen said:
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))
Click to expand...
 
Back
Top