Science Forums 2

[halbower]

I've reviewed the formula you have on your website. Unfortunately I cannot confirm the claims you have made.

The formula does indeed return prime numbers. However, it stops at 31. From then on, it is inaccurate.

I typed in your original value (2.566,543,832,171,388,844,467,529) into cell E4.


Here are my results using Excel

<Column E> ..... <Column F>
2.56654383217138 ..... 2
3.53017698972142 ..... 3
5.65848774684910 ...... 5
7.59315571766559 ...... 7
11.80128555035950...... 11
13.72794005216370...... 13
17.85861344125680...... 17
19.79936393159150...... 19
23.76889830664600...... 23
29.91292840834680...... 29
31.76590818607170...... 31
40.47482526462880...... 40
84.24151573163120...... 84
347.80343057844900...... 347
431.89792535625600...... 431
479.99535484443000...... 479
481.23541336079800...... 481
2043.21453281222000 ...... 2043

The formula stopped identifying correct prime numbers after 31. It missed 37 but picked 40.

Here is the Excel formula I used:

(Column E formula) (Column F formula)
=(E4/F4-1)^-1 ..... =int(E4)

I dragged this formula down. Above you can see the results. If there is an error in my logic, please post it.