View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] jsollows@gmail.com is offline
external usenet poster
 
Posts: 8
Default Excel makes an error

I am currious to find an explanation for this. In excel I created a
simple formula to calculate 12 to the 19th power written in full
numerical form. At 12 to the 17th excel makes an error (note the
zero's). Try it yourself. Anyone know why this happens?

12
144.00
1728.00
20736.00
248832.00
2985984.00
35831808.00
429981696.00
5159780352.00
61917364224.00
743008370688.00
8916100448256.00
106993205379072.00
1283918464548860.00 <-- here is where the error starts, the number
should end with 864.00
15407021574586400.00
184884258895036000.00
2218611106740440000.00
26623333280885200000.00
319479999370623000000.00

Try this with any really large number. The calculations drop off at the
17th digit. I've tried this on different computers all with the same
result.