Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =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))))),
- IF(MOD(ROW(),COLUMN())=0,IF(ROW()/COLUMN()>1000,1,INDIRECT(ADDRESS(FLOOR(ROW()/COLUMN(),1),
- 1))),"")))),"")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement