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 |
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 |
All times are GMT +1. The time now is 12:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com