how can I multiply a 45-vector times a 45*45 matrix?

J

jortorzor

Excel only accepts small matrices (10*10) for multiplication and inversion.
How can I extend these capabilities to larger matrices (50*50)?
 
F

Fredrik Wahlgren

jortorzor said:
Excel only accepts small matrices (10*10) for multiplication and inversion.
How can I extend these capabilities to larger matrices (50*50)?
Click to expand...

Here's a link to a site withe a more capable version of MMULT, MMULT.EXT
http://xcell05.free.fr/

/Fredrik
 
J

Jerry W. Lewis

Excel will invert up to a 52*52 matrix, assuming that it is numerically
nonsingular. What is MDETERM() of your matrix?

Jerry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add 45 days to a date.... 4
Matrix operations with complex numbers 1
adding hours and minutes 7
Aggregate the time data (mm/dd/yyyy:hh:mm:ss) into the 3 hours range 0
Column multiplied by a matrix 2
How to use matrix operations to create a "lag value" matrix 1
Rounding hh:mm to nearest 15, 30, 45 minutes 4
How can I have 45 mulitple sheets with 45 different acess rights to view to each sheet 3

Top