HI,
i have the below formula which is working fine.
=MMULT(MINVERSE({1,1,1;4,2,1;9,3,1}),L7:L9)
how do i change the array part to links to cells. Excel isnt allowing me to do so saying "You cannot change part of an array.
This is what i want
=MMULT(MINVERSE({A1^2,B1,1;A2^2,B2,1;A3^2,B3,1}),L7:L9)