Advertisement
MatsGranvik

twin prime sieve in Excel

Dec 28th, 2016
213
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.46 KB | None | 0 0
  1. =IF(ROW()>=COLUMN(),IF(AND(ROW()=1,COLUMN()=1),1,IF(AND(ROW()=2,COLUMN()=1),0,IF(COLUMN()=1,SIGN((1-PRODUCT(INDIRECT(ADDRESS(ROW(),2)&":"&ADDRESS(ROW(),ROW())))+1-PRODUCT(INDIRECT(ADDRESS(ROW()-2,2)&":"&ADDRESS(ROW()-2,ROW()-2))))*(1-PRODUCT(INDIRECT(ADDRESS(ROW(),2)&":"&ADDRESS(ROW(),ROW())))+1-PRODUCT(INDIRECT(ADDRESS(ROW()+2,2)&":"&ADDRESS(ROW()+2,ROW()+2))))),
  2. IF(MOD(ROW(),COLUMN())=0,IF(ROW()/COLUMN()>1000,1,INDIRECT(ADDRESS(FLOOR(ROW()/COLUMN(),1),
  3. 1))),"")))),"")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement