Operating on Complex Numbers

  • Thread starter Thread starter Charles
  • Start date Start date
C

Charles

I see how in the engineering formulas you can enter a complex number, but I
don't seem to be able to multiply them using the usual * function. Is there
some special way you are supposed to operate on complex numbers?

Thanks
 
In the Excel help file under "Engineering functions" you will find several functions that claim to deal with complex
numbers: "Complex" and "Imaginary" for starters.
The help file subject may be different in your version of Excel as MS makes random changes in each new release.

Also, here is a reference on using VBA code to format complex numbers...
http://support.microsoft.com/kb/213294
--
Jim Cone
Portland, Oregon USA
Review of Special Sort add-in...
( http://www.contextures.com/excel-sort-addin.html )




"Charles" <[email protected]>
wrote in message I see how in the engineering formulas you can enter a complex number, but I
don't seem to be able to multiply them using the usual * function. Is there
some special way you are supposed to operate on complex numbers?

Thanks
 
Hi. The function "IMPRODUCT" is what you need.

=IMPRODUCT(A1,A2)

= = = = = =
HTH :>)
Dana DeLouis
 
Back
Top