Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a formula that collects data, adds it and puts the information in
cells in a column. Each row in the column uses the same formula and collects the same data but for a different hour. Most of the time the resulting numer is rounded off by the formula. At the bottom of the column is a cell that totals all the numbers in the column. What would cause the information in this total cell to round down when all the numbers in the column are whole numbers? Add the numbers with a calculator and you get a different number that what the total cell has. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Rounding numbers up or down | Excel Discussion (Misc queries) | |||
Rounding off numbers in Excel 2003 | Excel Worksheet Functions | |||
Averaging and Rounding problem | Excel Worksheet Functions | |||
How do I get my formula to stop rounding up | Excel Worksheet Functions | |||
Rounding up for down based on cell value | Excel Worksheet Functions |