Module complex 

Functions

complex_fn

COMPLEX(real, imaginary, [suffix]) — create a complex number string.

imabs_fn

IMABS(complex) — return absolute value (modulus) of complex number.

imaginary_fn

IMAGINARY(complex) — return imaginary part of complex number.

imargument_fn

IMARGUMENT(complex) — argument (angle) of complex number.

imconjugate_fn

IMCONJUGATE(complex) — complex conjugate.

imcos_fn

IMCOS(complex) — cosine of complex number.

imcosh_fn

IMCOSH(complex) — hyperbolic cosine of complex number.

imcot_fn

IMCOT(complex) — cotangent of complex number. Uses double-angle formula for precision matching Google Sheets: cot(a+bi) = sin(2a)/(cosh(2b)-cos(2a)) - i*sinh(2b)/(cosh(2b)-cos(2a))

imcoth_fn

IMCOTH(complex) — hyperbolic cotangent of complex number. Uses double-angle formula for precision matching Google Sheets: coth(a+bi) = sinh(2a)/(cosh(2a)-cos(2b)) - i*sin(2b)/(cosh(2a)-cos(2b))

imcsc_fn

IMCSC(complex) — cosecant of complex number.

imcsch_fn

IMCSCH(complex) — hyperbolic cosecant of complex number.

imdiv_fn

IMDIV(complex1, complex2) — divide complex numbers.

imexp_fn

IMEXP(complex) — e raised to a complex power.

imln_fn

IMLN(complex) — natural log of complex number. GS always returns results with ‘i’ suffix, regardless of input notation.

imlog2_fn

IMLOG2(complex) — base-2 log of complex number.

imlog10_fn

IMLOG10(complex) — base-10 log of complex number.

imlog_fn

IMLOG(complex, base) — general log of complex number.

impower_fn

IMPOWER(complex, number) — complex number raised to a power.

improduct_fn

IMPRODUCT(complex1, ...) — product of complex numbers.

imreal_fn

IMREAL(complex) — return real part of complex number.

imsec_fn

IMSEC(complex) — secant of complex number.

imsech_fn

IMSECH(complex) — hyperbolic secant of complex number.

imsin_fn

IMSIN(complex) — sine of complex number.

imsinh_fn

IMSINH(complex) — hyperbolic sine of complex number.

imsqrt_fn

IMSQRT(complex) — principal square root of complex number.

imsub_fn

IMSUB(complex1, complex2) — subtract complex numbers.

imsum_fn

IMSUM(complex1, ...) — sum of complex numbers.

imtan_fn

IMTAN(complex) — tangent of complex number. Uses double-angle formula for precision matching Google Sheets: tan(a+bi) = sin(2a)/(cos(2a)+cosh(2b)) + i*sinh(2b)/(cos(2a)+cosh(2b))

imtanh_fn

IMTANH(complex) — hyperbolic tangent of complex number. Uses double-angle formula for precision matching Google Sheets: tanh(a+bi) = sinh(2a)/(cosh(2a)+cos(2b)) + i*sin(2b)/(cosh(2a)+cos(2b))