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"
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

Use COMPLEX(), which is an ordinary Excel function, to
convert real and imaginary coefficients into a complex number.
All functions for complex numbers reside in Analysis ToolPak
(not my spelling :-) and start with IM (e.g IMABS()), so you have
to install and activate Analysis ToolPak (Tools Add-ins) in
order to use those functions.

all the best

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

=IMPRODUCT(A1,A2)

= = = = = =
HTH :)
Dana DeLouis

On 5/23/10 10:41 PM, Charles wrote:
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