How To Delete Cookies - How To Delete Cookies last updated on: 11/10/16 08:43AM
 Solution numbers don t add up in Excel 2007 due to rounding [04/07/16 11:05AM]
 Rate this post

## numbers & % don't add up in Excel 2007 due to rounding

I am using Excell 2007 to present some number in billions in a table.  I am running into rounding errors (I think) as illustrated by the following example:  between 1997 and 1998, a number changed from \$2,280,802,396 to \$2,245,648,007.
The difference is
\$35,154,389.  However, when I present the data at the billions level \$2.3 billion - \$2.2 billion the difference is \$.1 billion which in my book is substantially higher than the actual difference.  Is there any way to avoid what appears to me to be an error
driven by rounding?
Al

## Anwsers to the Problem numbers & % don't add up in Excel 2007 due to rounding

I am using Excell 2007 to present some number in billions in a table.  I am running into rounding errors (I think) as illustrated by the following example:  between 1997 and 1998, a number changed from \$2,280,802,396 to \$2,245,648,007.
The difference is
\$35,154,389.  However, when I present the data at the billions level \$2.3 billion - \$2.2 billion the difference is \$.1 billion which in my book is substantially higher than the actual difference.  Is there any way to avoid what appears to me to be an error
driven by rounding?
Al

What do you expect to see?  Given that you are showing only 1 decimal place, how do you expect to see a more detailed representation of the difference than at the 100 million level?  If you go to 2 decimal places you'll see 2.28 and 2.25.

Tushar Mehta (Technology and Operations Consulting)
www.tushar-mehta.com (Excel and PowerPoint add-ins and tutorials)
Microsoft MVP Excel 2000-Present

## Another Safe way to Fix the problem: numbers & % don't add up in Excel 2007 due to rounding:

### How to Fix numbers & % don't add up in Excel 2007 due to rounding with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your system.  Open it, and it will perform a scan for your system. The errors will be shown in the list.

2. After the scan is done, you can see the errors and problems need to be repaired. Click Fix All.

3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been fixed.

Related: [Solved] Creating labels in Microsoft Word Starter,How to defrag my system? [Anwsered],Solution to Error: I can't find windows journal in my Windows 7 OS. It is included in the Starter edition?,Scripted Diagnostics Native Host not working,How to Resolve - system restore points keep vanishing in windows 7?,Solution to Error: Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,I'm always being signed off so annoying Tech Support
,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.
,Solution to Problem: Referencing data in another file
,Troubleshoot:Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive. Error,External Hard Drive not listed in Windows 7 backup wizard Tech Support,Tech Support: I'm always being signed off so annoying,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.,Referencing data in Access using Excel [Anwsered],Need Best Way To Present Data [Anwsered],Same question but for windows 7 home edition,sometimes fullscreen won't activate [Solved],Solution to Error: We bought a new computer with windows 7 and it is constantly freezing. How do we fix this?,Solution to Error: Windows 8 update crash (2013-07-22),Troubleshooting:pfstudiox Error,[Solved] Svchost Helper,[Solution] Sm1bg exe,How to Fix Problem - Io Device?,Fast Solution to Problem: I Can Error Code 0x6d9
Read More: How Can You Fix - Nothing happens when I instert flash drive, I insterted it in a different computer and it still does not work, what can I do??,number of pages initially wrong on first page when "different first page" selected Tech Support,Troubleshooting:NT Kernel high cpu usage,How to Fix - Numbering after Table of Contents?,How Can You Fix - " DRIVER_IRQL_NOT_EQUAL_OR_LESS " error in windows 7?,Need to change the programs in Start Up mode.,needing to correct error- 0x80070002,New windows7 machine won't connect to my older vista network/workgroup,New Dell Inspiron 20 mouse will not work,New Windows 7 Asus laptop won't connect to internet

Name:

Email:

1 + 5 = ?

Please write above the sum of these two integers

Title:

Contact the author
Categories

Latest blog posts
 Error Yahoo has been banned Anwsered[11/10/16 08:43AM]How to Resolve Disk Boot Failure insert system disk after I do this the windows menu comes up and wont show a hard drive help[27/09/16 05:12AM]How to Resolve Disk Boot Failure insert system disk after I do this the windows menu comes up and wont show a hard drive help[27/09/16 05:10AM]Anwsered Cannot read mails using Windows Live Mail[14/09/16 04:42AM]Solution to Error Windows Index Score very low[13/07/16 05:35AM]
Top views posts
 Anwsered Cannot read mails using Windows Live Mail[14/09/16 04:42AM] Daily Views 9Solution numbers don t add up in Excel 2007 due to rounding[04/07/16 11:05AM] Daily Views 2How to Resolve Disk Boot Failure insert system disk after I do this the windows menu comes up and wont show a hard drive help[27/09/16 05:12AM] Daily Views 2How Can You Fix notepad a free gun source code editor has stopped working[04/07/16 11:06AM] Daily Views 1Solution to Error Windows Index Score very low[13/07/16 05:35AM] Daily Views 1
Photo Albums