ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   What am I doing wrong? (https://www.excelbanter.com/excel-discussion-misc-queries/71186-what-am-i-doing-wrong.html)

PFB1033

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



bpeltzer

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