Forum Discussion

Iron Contributor

Apr 08, 2026

Formula for Complex Matrices

Hi Microsoft Community Hub, I am excited to share a new method I have developed for solving matrices with complex numbers. As many of you know, handling complex matrix operations in environme...

excel

JohnVergaraD

Copper Contributor

Apr 09, 2026

Hi IlirU!

This could be another option (you do not need MAP in this formula):

=LET(m,+A2:J11,c,+L2:L11,n,ROWS(m),R,IMREAL,I,IMAGINARY,V,VSTACK,S,MMULT(MINVERSE(HSTACK(V(R(m),I(m)),V(-I(m),R(m)))),V(R(c),I(c))),COMPLEX(TAKE(S,n),DROP(S,n)))

Blessings!

IlirU

Iron Contributor

Apr 10, 2026

JohnVergaraD,

Thank you for the changes you suggested to my formula. In this case the formula could be written as follows:

=LET(
     mat, +A2:J11,
    coef, +L2:L11,
      ir, IMREAL(mat),
      im, IMAGINARY(mat),
      rw, ROWS(mat),
    calc, MMULT(MINVERSE(HSTACK(VSTACK(ir, im), VSTACK(-im, ir))),
          VSTACK(IMREAL(coef),
          IMAGINARY(coef))),
          COMPLEX(TAKE(calc, rw), DROP(calc, rw))
)

Have a nice day.