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?