Thread: Matrix analysis
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
filo666 filo666 is offline
external usenet poster
 
Posts: 265
Default Matrix analysis

I'm trying to solve a system of equations, I have 9 unknowns and 10
equations; the solution of the equation exists depending upon the
coefficients of the equations; for example, If I dont get the solution with
the first 9 equations, I can change one of the original equation with the
tenth equation and look if there is a solution, if not I change another
equation until the solution is found.

My problem is that I can not explain excel how to add two ranges with the
=mdeterm function; for example:

A B C
1 2 3 4
2 1 0 3

=mdeterm(a1:b2) has a solution
I can not jump the B column and still have a range; for instance, this
formula does not work: =mdeterm(a1:a2,c1:c2)
How can I explain excel or the function that it needs to consider the range
jumping whatever number of columns?