View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bpeltzer
 
Posts: n/a
Default 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