Looking for some help with the sum of rounded figures not equal to zero.
I extracted a list of numbers that are in three decimals. The sum of the list is zero. In a separate column I rounded the numbers to "0" decimals however, the sum is now not zero. Is someone familiar with this problem? I used the Goal Seek option but still no solution.
Hi - can you please provide a sample so we can take a look?
Why would it be? The values could be less than or greater than the original values depending on if they round down or up.... however, the sum is now not zero.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hello mikeava, thanks for your prompt reply.
I am looking to see how I can submit an attachment as the example. Failing that, can I email to you?
the excel file I am working with is 2105 rows, 94kb. Can I submit like that?
If you just want to provide a small sample that is fine.
In your reply Scroll down and click on Go Advanced
Scroll down and click on Manage Attachments
Under Additional Options click again on Manage Attachments.
New window opens - click on Choose File and select your file
Click on Upload
Scroll down and Close Window
Click on Submit
Thanks...here is the file.
Thanks for uploading the file. Just an FYI - It always helps others when they can see what you are referring to.
I have to agree with TMS it has to do with the rounding. You lose some value in one amount when you round down, and gain some when you round up.
Yep, like I said. Some values go up, some go down. If you want an accurate sum, don't use rounding.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks