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

hi Harlan,

MINVERSE and MMULT work , have not tried MDETERM but expect that will work
as well.


regards
Charles
______________________
Decision Models
FastExcel 2.2 Beta now available
www.DecisionModels.com

"Harlan Grove" wrote in message
ups.com...
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?