Why is a row's total rounding up?
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
"PHRed" wrote:
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?
|