View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default 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?