Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What am I doing wrong?
Following is a multiplicaiton done in Excel that seems to have a wrong answer?
111,111,111 x 111,111,111 = 12,345,678,987,654,300 Try it, see if you have get the same answer. The last 2 digits in the answer should be "21" ----- Any enlightenment would be appreciated. Respectfully, PF Brennan |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
What am I doing wrong?
Excel stores and calculates with 15 significant digits of precision; you've
gone beyond that limit. "PFB1033" wrote: Following is a multiplicaiton done in Excel that seems to have a wrong answer? 111,111,111 x 111,111,111 = 12,345,678,987,654,300 Try it, see if you have get the same answer. The last 2 digits in the answer should be "21" ----- Any enlightenment would be appreciated. Respectfully, PF Brennan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT is showing wrong Amount | Excel Discussion (Misc queries) | |||
hyperlink navigation path path wrong in Excel 2003 | Excel Discussion (Misc queries) | |||
wrong year | Excel Worksheet Functions | |||
What is Wrong with this formula please? | New Users to Excel | |||
Logic statement returns wrong answer. | Excel Worksheet Functions |