Excel 12, er, 2007 - Semi-idle Curiosity
You haven't dl'd beta 2 ?
I haven't either! If I could get just Excel and not the whole Office suite
I'd love to play with it.
Biff
"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?
|