Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why is a row's total rounding up?
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why is a row's total rounding up?
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 "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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
print area selection slows excel, formula for hiding rows?? | Excel Discussion (Misc queries) | |||
formula to use when number of rows changes dynamically | Excel Worksheet Functions | |||
Rounding percentage's of the total | Excel Discussion (Misc queries) | |||
Subtract several rows from a total | New Users to Excel | |||
Deleting rows containing common data | Excel Discussion (Misc queries) |