Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing large numbers with decimals in Excel
Hi,
I am having problem when summing large numbers with decimals. Here is the sample. Copy these numbers to the excel sheet and sum them. 1,094,997,817.3305 84,045,000.0000 2,238,305,000.0000 35,770,000.0000 737,995,000.0000 187,980,000.0000 7,750,000.0000 172,900,000.0000 7,100,975.0000 94,154,750,000.0000 16,034,600,000.0000 306,545,000.0000 136,240,000,000.0000 91,995,000.0000 564,407,961.0000 Make sure that the decimals are 4 digits. When we sumi this the result is 251,959,141,753.3310. I have only on decimal value 3305. But in the sum the values is 3310. Any idea ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing large numbers with decimals in Excel
Excel only keeps track of 15 significant digits.
PradeepKel wrote: Hi, I am having problem when summing large numbers with decimals. Here is the sample. Copy these numbers to the excel sheet and sum them. 1,094,997,817.3305 84,045,000.0000 2,238,305,000.0000 35,770,000.0000 737,995,000.0000 187,980,000.0000 7,750,000.0000 172,900,000.0000 7,100,975.0000 94,154,750,000.0000 16,034,600,000.0000 306,545,000.0000 136,240,000,000.0000 91,995,000.0000 564,407,961.0000 Make sure that the decimals are 4 digits. When we sumi this the result is 251,959,141,753.3310. I have only on decimal value 3305. But in the sum the values is 3310. Any idea ? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel won't sort numbers correctly | Excel Discussion (Misc queries) | |||
How to make excel not round real numbers when making a histogram? | Charts and Charting in Excel | |||
Sorting Numbers with Multiple Decimals (cont.) | Excel Discussion (Misc queries) |