View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove
 
Posts: n/a
Default Excel 12, er, 2007 - Semi-idle Curiosity

Do XL12's MINVERSE and MDETERM handle arrays larger than 51 rows by 51
columns? Also, does the array formula
=MMULT(TRANSPOSE(ROW(1:100000)),ROW(1:100000)) return 3.3333833335E+14
[from the formula for the sum of squares from 1 to N = N (N+1) (2N+1) /
6]? Increase 100000 to 1000000, and does it return 3.333338333335E+17 ?
Or do the NDAs prevent you from saying?