Complex numbers

  • Thread starter Thread starter bill
  • Start date Start date
B

bill

I am trying to do some manipulation of complex numbers.
What I want to do is take the values from two adjacent
cells and then make them into the real and imaginary
components of a complex number. I then want to calculate
the exponential value of this complex number. Anybody done
this before? I don't mind whether it is done in VB or as a
formula in a cell.
 
The Imaginary function returns the imaginary coefficient
and IMReal returns the real coefficient.
HTH.
 
With a Real in A1, and the Imag. in B1...

C1 -> =COMPLEX(A1,B1)
D1 -> =IMEXP(C1)

or together...
=IMEXP(COMPLEX(A1,B1))

HTH
Dana DeLouis
 
Back
Top