Operating on Complex Numbers

[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

 

[Jim Cone]

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

 

[Dana DeLouis]

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

=IMPRODUCT(A1,A2)

= = = = = =
HTH :>)
Dana DeLouis