Limitation of Excel

Written on 5 October, 2000

1) For 479 = 1,119,130,473,102,767

but if you use excel to calculate, the figure will be 1,119,130,473,102,770.

I have tried 479, 489, 499, ..., 649, and got similar errors, except some of

the numbers ending with 0.

Most probably, error starts from nx, where n > 46 and x > 8.

 

2) For 1397 = 1,002,544,368,429,379

but if you use excel to calculate, the figure will be 1,002,544,368,429,380.

I have tried 1397, 1407, 1417, ..., 355357, and got similar errors, except

some of the numbers ending with 0.

Most probably, error starts from NY, where N > 138 and Y > 6.

 

3) For 3176 = 1,014,741,853,230,169

but if you use excel to calculate, the figure will be 1,014,741,853,230,170.

I have tried 3176, 3186, 3196, ..., 15196, and got similar errors, except

some of the numbers ending with 0.

Most probably, error starts from mz, where m > 316 and z > 5.

 

4) For 56244 = 1,000,417,426,149,376

but if you use excel to calculate, the figure will be 1,000,417,426,149,380.

I have tried 56244, 56254, 56264, ..., 655354, and got similar errors, except

some of the numbers ending with 0.

Most probably, error starts from Cd, where C > 5623 and d > 3.

 

5) For 31,622,7772 = 1,000,000,025,191,729

but if you use excel to calculate, the figure will be 1,000,000,025,191,730.

I have tried 31,622,7772, 31,622,7782, 31,622,7792, ..., 31,686,1332, and

got similar errors, except some of the numbers ending with 0.

Most probably, error starts from Ma, where M > 31,622,776 and a > 1.

P.S. Similar errors were obtained in Lotus 1-2-3.

Counter

[Recurring Pattern] [Relation with the Magic Square] [Create a Magic Square by Excel]

[Magic Circle = Magic Polyhedron ?] [Something Other Than Mathematics (in Big5)] [Home]