Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / November 2006

Tip: Looking for answers? Try searching our database.

complex calculation

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Betsie - 28 Nov 2006 13:55 GMT
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 - 28 Nov 2006 14:07 GMT
Hi Betsie
In Help, use the word 'imaginary' to do a search.
You will find IMPRODUCT and IMDIV
best wishes
Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> Does anyone know how to perform a calculation (multiply/divide/...)
> between
[quoted text clipped - 11 lines]
>
> I look forwards to hearing from anyone who knows how to solve the problem
Betsie - 28 Nov 2006 15:23 GMT
Thank you very much :) :)

> Hi Betsie
> In Help, use the word 'imaginary' to do a search.
[quoted text clipped - 15 lines]
> >
> > I look forwards to hearing from anyone who knows how to solve the problem
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.