Home |
Search |
Today's Posts |
#1
|
|||
|
|||
why do numbers not add correctly in excel
When adding currency in an excel worksheet, the sums are not always correct .
They may be a penny higher or a penny lower than the correct amount. Some of the amounts that are being added are obtained by using a percentage of another amount. |
#2
|
|||
|
|||
Take a look at JE McGimpsey's site:
http://www.mcgimpsey.com/excel/pennyoff.html kflag wrote: When adding currency in an excel worksheet, the sums are not always correct . They may be a penny higher or a penny lower than the correct amount. Some of the amounts that are being added are obtained by using a percentage of another amount. -- Dave Peterson |
#3
|
|||
|
|||
It's because Excel holds a far greater precision than that displayed by the
format. You may see 1.50+1.50 and expect 3.00, but Excel may be holding a true value of 1.5049+1.5049=3.098 or formatted to two decimals 3.01 To overcome this you can use the ROUND function on all your calculations, or go to ToolsOptionsCalculationPrecision as displayed -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "kflag" wrote in message ... When adding currency in an excel worksheet, the sums are not always correct . They may be a penny higher or a penny lower than the correct amount. Some of the amounts that are being added are obtained by using a percentage of another amount. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel Adding duplicated numbers together | Excel Discussion (Misc queries) | |||
how do i set up to auto detect duplicated numbers in an excel fiel | Excel Discussion (Misc queries) | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
How do i increase the size of numbers in a text in Excel. | Excel Worksheet Functions |