F
filo666
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 don’t 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?
equations; the solution of the equation exists depending upon the
coefficients of the equations; for example, If I don’t 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?