Operating on Complex Numbers
in [General]
|
Prev: I want to calculate the grade I need to get an A in my class
Next: Pivot Table Page Field value from cell in another worksheet
From: Charles on 23 May 2010 22:41 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
From: Jim Cone on 24 May 2010 00:25 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" <Charles(a)discussions.microsoft.com> wrote in message news:9DCDF81C-A335-4BE4-B0CA-49B3EC0C33BF(a)microsoft.com... 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
From: Dana DeLouis on 24 May 2010 17:50
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 |