So have a set of numbers in a column that is labeled by division All the number are whole numbers with no decimal and manually input, when I highlight each divisions set of numbers the status bar shows me a rounded number which contributes to the total column summed higher than the number is should show (10 to be exact). What is going on and how do I fix?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Sum Rounding, incorrect sum
- Thread starter Dmccurry
- Start date
jasonb75
Well-known Member
- Joined
- Dec 30, 2008
- Messages
- 15,507
- Office Version
- 365
- Platform
- Windows
This is practically impossible to answer without seeing the data however it is highly unlikely that the figure in the status bar is incorrect and more likely that there is something which you haven't noticed in the data.
Whilst rounding errors are possible in some situations, the discrepancy would be a minuscule decimal value rather than a difference of 10 as you say you are seeing.
Whilst rounding errors are possible in some situations, the discrepancy would be a minuscule decimal value rather than a difference of 10 as you say you are seeing.
Upvote
0
Sulprobil
Banned user
- Joined
- May 12, 2020
- Messages
- 231
- Office Version
- 2021
- Platform
- Windows
Is this thread offering a fix for you?:
www.mrexcel.com
Rounding numbers to total a specific number?
Hello all, Apologies if this is not possible but I have the following situation: C D E F G H I (Total) 43.44559 156.9966 246.8499 210.3162 133.299 71.09278 862 I would like to round up each of these cells to the closest number but also so that they match the total in column I? If...
Upvote
0
