MatsGranvik

von Mangoldt function matrix

Sep 24th, 2012
316
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.70 KB | None | 0 0
  1. von Mangoldt matrix recurrence:
  2.  
  3. =IF(OR(ROW()=1; COLUMN()=1); 1; IF(ROW()>=COLUMN(); -SUM(INDIRECT(ADDRESS(ROW()-COLUMN()+1;
  4. COLUMN(); 4)&":"&ADDRESS(ROW()-1; COLUMN(); 4); 4)); -SUM(INDIRECT(ADDRESS(COLUMN()-ROW()+1;
  5. ROW(); 4)&":"&ADDRESS(COLUMN()-1; ROW(); 4); 4))))
  6.  
  7. written as a European Excel spreadsheet formula to be entered in cell A1.
  8.  
  9. American version
  10.  
  11. =IF(OR(ROW()=1, COLUMN()=1), 1, IF(ROW()>=COLUMN(), -SUM(INDIRECT(ADDRESS(ROW()-COLUMN()+1,
  12. COLUMN(), 4)&":"&ADDRESS(ROW()-1, COLUMN(), 4), 4)), -SUM(INDIRECT(ADDRESS(COLUMN()-ROW()+1,
  13. ROW(), 4)&":"&ADDRESS(COLUMN()-1, ROW(), 4), 4))))
  14.  
  15. keywords: von Mangoldt function, Dirichlet inverse of Euler totient function, greatest common divisor.
Advertisement
Add Comment
Please, Sign In to add comment