complex calculation
 

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

complex calculation
 

Hi Betsie
In Help, use the word 'imaginary' to do a search.
You will find IMPRODUCT and IMDIV
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Betsie" wrote in message
...
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

complex calculation
 

Thank you very much :) :)

"Bernard Liengme" wrote:

Hi Betsie
In Help, use the word 'imaginary' to do a search.
You will find IMPRODUCT and IMDIV
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Betsie" wrote in message
...
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