complex calculation

[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

 

[Bernard Liengme]

Hi Betsie
In Help, use the word 'imaginary' to do a search.
You will find IMPRODUCT and IMDIV
best wishes

 

[Guest]

Thank you very much

Hi Betsie
In Help, use the word 'imaginary' to do a search.
You will find IMPRODUCT and IMDIV
best wishes