LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Danny
 
Posts: n/a
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rounding numbers up or down boyshanks Excel Discussion (Misc queries) 13 April 8th 09 03:03 PM
Rounding off numbers in Excel 2003 Joe Tahoe Excel Worksheet Functions 4 July 28th 05 03:08 AM
Averaging and Rounding problem Hansel Excel Worksheet Functions 5 June 21st 05 03:24 AM
How do I get my formula to stop rounding up SheltieGrl Excel Worksheet Functions 1 March 11th 05 06:23 PM
Rounding up for down based on cell value Allison Excel Worksheet Functions 3 February 8th 05 10:10 PM


All times are GMT +1. The time now is 07:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"