Complex numbers

[Alain Turgeon]

I would like to know if there is some possiblities to use
complex variable to do calculation in a subroutine or if
you have to use real number and do the calculation by
yourself.

Thanks very much!

 

[Niek Otten]

Complex numbers functions are in the Analysis Toolpak add-in. Tools>Add-in,
check Analysyis Toolpak and the VBA version.
Look in Help for details, or do a Google Groups search:
http://groups.google.com/advanced_group_search
with the exact phrase "complex numbers" in the groups "*excel*"


--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Tom Ogilvy]

the analysis toolpak has some routines for working with complex numbers I
believe.

for example:

the Complex function
and

IMABS Returns the absolute value (modulus) of a complex number

IMAGINARY Returns the imaginary coefficient of a complex number

IMARGUMENT Returns the argument theta, an angle expressed in radians

IMCONJUGATE Returns the complex conjugate of a complex number

IMCOS Returns the cosine of a complex number

IMDIV Returns the quotient of two complex numbers

IMEXP Returns the exponential of a complex number

IMLN Returns the natural logarithm of a complex number

IMLOG10 Returns the base-10 logarithm of a complex number

IMLOG2 Returns the base-2 logarithm of a complex number

IMPOWER Returns a complex number raised to an integer power

IMPRODUCT Returns the product of two complex numbers

IMREAL Returns the real coefficient of a complex number

IMSIN Returns the sine of a complex number

IMSQRT Returns the square root of a complex number

IMSUB Returns the difference of two complex numbers

IMSUM Returns the sum of complex numbers