See Release Notes
Long Term Support Release
Differences Between: [Versions 400 and 401]
(no description)
File Size: | 611 lines (20 kb) |
Included or required: | 0 times |
Referenced: | 0 times |
Includes or requires: | 0 files |
Class: ComplexFunctions - X-Ref
IMABS($complexNumber) X-Ref |
IMABS. Returns the absolute value (modulus) of a complex number in x + yi or x + yj text format. Excel Function: IMABS(complexNumber) param: array|string $complexNumber the complex number for which you want the absolute value return: array|float|string |
IMARGUMENT($complexNumber) X-Ref |
IMARGUMENT. Returns the argument theta of a complex number, i.e. the angle in radians from the real axis to the representation of the number in polar coordinates. Excel Function: IMARGUMENT(complexNumber) param: array|string $complexNumber the complex number for which you want the argument theta return: array|float|string |
IMCONJUGATE($complexNumber) X-Ref |
IMCONJUGATE. Returns the complex conjugate of a complex number in x + yi or x + yj text format. Excel Function: IMCONJUGATE(complexNumber) param: array|string $complexNumber the complex number for which you want the conjugate return: array|string |
IMCOS($complexNumber) X-Ref |
IMCOS. Returns the cosine of a complex number in x + yi or x + yj text format. Excel Function: IMCOS(complexNumber) param: array|string $complexNumber the complex number for which you want the cosine return: array|float|string |
IMCOSH($complexNumber) X-Ref |
IMCOSH. Returns the hyperbolic cosine of a complex number in x + yi or x + yj text format. Excel Function: IMCOSH(complexNumber) param: array|string $complexNumber the complex number for which you want the hyperbolic cosine return: array|float|string |
IMCOT($complexNumber) X-Ref |
IMCOT. Returns the cotangent of a complex number in x + yi or x + yj text format. Excel Function: IMCOT(complexNumber) param: array|string $complexNumber the complex number for which you want the cotangent return: array|float|string |
IMCSC($complexNumber) X-Ref |
IMCSC. Returns the cosecant of a complex number in x + yi or x + yj text format. Excel Function: IMCSC(complexNumber) param: array|string $complexNumber the complex number for which you want the cosecant return: array|float|string |
IMCSCH($complexNumber) X-Ref |
IMCSCH. Returns the hyperbolic cosecant of a complex number in x + yi or x + yj text format. Excel Function: IMCSCH(complexNumber) param: array|string $complexNumber the complex number for which you want the hyperbolic cosecant return: array|float|string |
IMSIN($complexNumber) X-Ref |
IMSIN. Returns the sine of a complex number in x + yi or x + yj text format. Excel Function: IMSIN(complexNumber) param: array|string $complexNumber the complex number for which you want the sine return: array|float|string |
IMSINH($complexNumber) X-Ref |
IMSINH. Returns the hyperbolic sine of a complex number in x + yi or x + yj text format. Excel Function: IMSINH(complexNumber) param: array|string $complexNumber the complex number for which you want the hyperbolic sine return: array|float|string |
IMSEC($complexNumber) X-Ref |
IMSEC. Returns the secant of a complex number in x + yi or x + yj text format. Excel Function: IMSEC(complexNumber) param: array|string $complexNumber the complex number for which you want the secant return: array|float|string |
IMSECH($complexNumber) X-Ref |
IMSECH. Returns the hyperbolic secant of a complex number in x + yi or x + yj text format. Excel Function: IMSECH(complexNumber) param: array|string $complexNumber the complex number for which you want the hyperbolic secant return: array|float|string |
IMTAN($complexNumber) X-Ref |
IMTAN. Returns the tangent of a complex number in x + yi or x + yj text format. Excel Function: IMTAN(complexNumber) param: array|string $complexNumber the complex number for which you want the tangent return: array|float|string |
IMSQRT($complexNumber) X-Ref |
IMSQRT. Returns the square root of a complex number in x + yi or x + yj text format. Excel Function: IMSQRT(complexNumber) param: array|string $complexNumber the complex number for which you want the square root return: array|string |
IMLN($complexNumber) X-Ref |
IMLN. Returns the natural logarithm of a complex number in x + yi or x + yj text format. Excel Function: IMLN(complexNumber) param: array|string $complexNumber the complex number for which you want the natural logarithm return: array|string |
IMLOG10($complexNumber) X-Ref |
IMLOG10. Returns the common logarithm (base 10) of a complex number in x + yi or x + yj text format. Excel Function: IMLOG10(complexNumber) param: array|string $complexNumber the complex number for which you want the common logarithm return: array|string |
IMLOG2($complexNumber) X-Ref |
IMLOG2. Returns the base-2 logarithm of a complex number in x + yi or x + yj text format. Excel Function: IMLOG2(complexNumber) param: array|string $complexNumber the complex number for which you want the base-2 logarithm return: array|string |
IMEXP($complexNumber) X-Ref |
IMEXP. Returns the exponential of a complex number in x + yi or x + yj text format. Excel Function: IMEXP(complexNumber) param: array|string $complexNumber the complex number for which you want the exponential return: array|string |
IMPOWER($complexNumber, $realNumber) X-Ref |
IMPOWER. Returns a complex number in x + yi or x + yj text format raised to a power. Excel Function: IMPOWER(complexNumber,realNumber) param: array|string $complexNumber the complex number you want to raise to a power param: array|float|int|string $realNumber the power to which you want to raise the complex number return: array|string |