Rounding and cell totals
 

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.

Likely you are not rounding the numbers, just formatting them.
Formatting changes the display, but not the actual value of the number.
Use the ROUND() function in the formula to actually change the value,
or go to Tools|Options|Calculation and check Precision as Displayed.

Jerry

Danny wrote:

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.

This might seem a silly question, but are you adding (with the
calculator) the numbers with the decimals or as whole numbers?
Next thing, if you highlight the column of numbers with the cursor and
check the sum that you will see in the bottom right hand sde of the
spreadsheet, is it the same as the total you get with the Sum(x:y)
statement?
Next: Is the format of all the cells in the resutls column the same -
are you rounding up, down or off - Set them all to the same rounding
and things should start looking better

Cheers


--
Jon Quixley
------------------------------------------------------------------------
Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803
View this thread: http://www.excelforum.com/showthread...hreadid=393260