Complex numbers
 

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!

Complex numbers
 

Complex numbers functions are in the Analysis Toolpak add-in. ToolsAdd-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

"Alain Turgeon" wrote in message
...
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!

Complex numbers
 

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



--

Regards,

Tom Ogilvy



"Alain Turgeon" wrote in message
...
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!