Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Analysis ToolPak Regression Analysis Help Requested | Excel Worksheet Functions | |||
Analysis Toolpak-Confidence Level and data analysis questions | Excel Worksheet Functions | |||
variance-covariance matrix (w/o data analysis kit) | Excel Programming | |||
In Regression Analysis, How do you get a Correlation Matrix to be. | Excel Discussion (Misc queries) | |||
Analysis ToolPak installed but no Data Analysis option | Excel Discussion (Misc queries) |