Operating on Complex Numbers

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
 
J

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
 
D

Dana DeLouis

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

=IMPRODUCT(A1,A2)

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to enable engineering functions in MS Excel 2000? 3
displaying complex number in Excel 2
Matrix operations with complex numbers 1
Complex numbers 2
complex calculations 6
complex calculation 2
Round-down complex numbers 7
Format cells for hexadecimal numbers 2

Top