ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I invert a complex matrix (https://www.excelbanter.com/excel-worksheet-functions/188867-how-do-i-invert-complex-matrix.html)

Greg Conway

How do I invert a complex matrix
 
How do I do an inversion of a matrix containing complex numbers.
The "minverse" function doesn't recognise complex numbers.
Even a small venture into Visual basic has proven unsuccessful.

Bernard Liengme

How do I invert a complex matrix
 
I think you have reached the outer edge of the Excel mathematical envelope.
(And mine!)
Its a problem for Mathimatica, MathCad or Maple
I am just experimenting with TK Solver and will see the documentation
mentions this.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Greg Conway" wrote in message
...
How do I do an inversion of a matrix containing complex numbers.
The "minverse" function doesn't recognise complex numbers.
Even a small venture into Visual basic has proven unsuccessful.




Greg Conway

How do I invert a complex matrix
 
Damn I can do it in SageMath, or on my programmable calculator but I was
hoping to be able to do it in excel.

"Bernard Liengme" wrote:

I think you have reached the outer edge of the Excel mathematical envelope.
(And mine!)
Its a problem for Mathimatica, MathCad or Maple
I am just experimenting with TK Solver and will see the documentation
mentions this.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Greg Conway" wrote in message
...
How do I do an inversion of a matrix containing complex numbers.
The "minverse" function doesn't recognise complex numbers.
Even a small venture into Visual basic has proven unsuccessful.





Greg Conway

How do I invert a complex matrix
 
I downloaded some VB code from http://www.alglib.net/matrixops/complex/inv.php

But I'm not a VB programmer and I'm struggling to do anything usefull with it.

"Bernard Liengme" wrote:

I think you have reached the outer edge of the Excel mathematical envelope.
(And mine!)
Its a problem for Mathimatica, MathCad or Maple
I am just experimenting with TK Solver and will see the documentation
mentions this.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Greg Conway" wrote in message
...
How do I do an inversion of a matrix containing complex numbers.
The "minverse" function doesn't recognise complex numbers.
Even a small venture into Visual basic has proven unsuccessful.






All times are GMT +1. The time now is 10:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com