| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I use MINVERSE in Excel?
I need to invert a 4x4 matrix in excel. I am doing something wrong because
all I get is the first term of the inverted matrix. There is obviously a simple answer ! |
|
#2
|
|||
|
|||
|
esoarerkt wrote...
I need to invert a 4x4 matrix in excel. I am doing something wrong because all I get is the first term of the inverted matrix. The inverse of a 4x4 matrix would also be a 4x4 matrix. In Excel you'd need to select a 4x4 range of cells, type the MINVERSE formula, then hold down [Ctrl] and [Shift] keys before pressing [Enter] in order to enter the formula as an array formula. Note that the first remark in online help for MINVERSE is "Formulas that return arrays must be entered as array formulas." |
|
#3
|
|||
|
|||
|
"Harlan Grove" wrote: esoarerkt wrote... I need to invert a 4x4 matrix in excel. I am doing something wrong because all I get is the first term of the inverted matrix. The inverse of a 4x4 matrix would also be a 4x4 matrix. In Excel you'd need to select a 4x4 range of cells, type the MINVERSE formula, then hold down [Ctrl] and [Shift] keys before pressing [Enter] in order to enter the formula as an array formula. Note that the first remark in online help for MINVERSE is "Formulas that return arrays must be entered as array formulas." |
|
#4
|
|||
|
|||
|
"esoarerkt" skrev: "Harlan Grove" wrote: esoarerkt wrote... I need to invert a 4x4 matrix in excel. I am doing something wrong because all I get is the first term of the inverted matrix. The inverse of a 4x4 matrix would also be a 4x4 matrix. In Excel you'd need to select a 4x4 range of cells, type the MINVERSE formula, then hold down [Ctrl] and [Shift] keys before pressing [Enter] in order to enter the formula as an array formula. Note that the first remark in online help for MINVERSE is "Formulas that return arrays must be entered as array formulas." It still do't work in Exel. I have installed Lotus 123 (anno 1995) and that works!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| How do I isolate my Excel server (automation) from other Excel instances? | Excel Discussion (Misc queries) | |||
| sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
| Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
| VB Automation is Whacking out my Excel Environment | Excel Discussion (Misc queries) | |||
Linear Mode
