Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 Custom Error Bars | Excel Discussion (Misc queries) | |||
Sharing Violation Error while opening Excel file with Win Runner | Excel Discussion (Misc queries) | |||
Problem Opening an Excel File MSO9.DLL Error | Links and Linking in Excel | |||
Run-time Error in Excel? | Excel Worksheet Functions | |||
error opening excel file | Excel Worksheet Functions |