Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =IF(((FLOOR((ROW(A1))/ COLUMN(A1),1) - FLOOR((ROW(A1))/ COLUMN(B1),1))*IF(ROW(A1)>=COLUMN(A1)*2,1,0)*IF(ROW(A1)<(COLUMN(A1))^2+COLUMN(A1),1,0)+IF(AND(ROW(A1)>=COLUMN(A1),ROW(A1)<=(COLUMN(A1)+1)^2-1),1,0)-SIGN((FLOOR((ROW(A1))/ COLUMN(A1),1) - FLOOR((ROW(A1))/ COLUMN(B1),1))*IF(ROW(A1)>=COLUMN(A1)*2,1,0)*IF(ROW(A1)<(COLUMN(A1))^2+COLUMN(A1),1,0)+IF(AND(ROW(A1)>=COLUMN(A1),ROW(A1)<=(COLUMN(A1)+1)^2-1),1,0)))*((ROW()-2*COLUMN()+1))=0,"",((FLOOR((ROW(A1))/ COLUMN(A1),1) - FLOOR((ROW(A1))/ COLUMN(B1),1))*IF(ROW(A1)>=COLUMN(A1)*2,1,0)*IF(ROW(A1)<(COLUMN(A1))^2+COLUMN(A1),1,0)+IF(AND(ROW(A1)>=COLUMN(A1),ROW(A1)<=(COLUMN(A1)+1)^2-1),1,0)-SIGN((FLOOR((ROW(A1))/ COLUMN(A1),1) - FLOOR((ROW(A1))/ COLUMN(B1),1))*IF(ROW(A1)>=COLUMN(A1)*2,1,0)*IF(ROW(A1)<(COLUMN(A1))^2+COLUMN(A1),1,0)+IF(AND(ROW(A1)>=COLUMN(A1),ROW(A1)<=(COLUMN(A1)+1)^2-1),1,0)))*((ROW()-2*COLUMN()+1)))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
