Complex numbers

[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.

 

[Peg]

The Imaginary function returns the imaginary coefficient
and IMReal returns the real coefficient.
HTH.

 

[Dana DeLouis]

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