Why is a row's total rounding up?

[Guest]

I am doing a spreadsheet and all the rows are adding up the same, except for
one, which is rounding its total up instead of putting the exact total in.
How do I get that to change?

 

[Guest]

If the data is decimal numbers then you can expect the "display" of totals to
be rounded up in some cases. See sample below.

A B C
0.20541 0.21 0.21000
0.50935 0.51 0.51000
0.94689 0.95 0.95000
1.63660 1.64 1.64000
3.29825 3.30 3.31000 <=== TOTAL

A is data displayed to 5 decimal places, B to 2 DP where total of 3.29 is
rounded to 3.30 on display and finally C is individual data rounded up to 2
figures.

HTH

 

[Guest]

Go to Format, Cells, Number and set the number of decimal places you want.
HTH - Sheila
www-c-i-m-s.com
MS Office training - London