complex calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know how to perform a calculation (multiply/divide/...) between
two complex numbers (x+iy)?

It seems that you can get the complex numbers in place using =complex(x,y)
but once on screen, e.g. cell A4 and A5, it does not seem possible to perform
=A4/A5.

I could work it out through by multiplying the complex cojugates and then
performing (A4*A5+)(A5*A5) but it seems to make the whole "having a complex
function availiable in Excell" pointless.

I look forwards to hearing from anyone who knows how to solve the problem
 
Hi Betsie
In Help, use the word 'imaginary' to do a search.
You will find IMPRODUCT and IMDIV
best wishes
 
Back
Top