• # Complex

• ## IMSUM

Returns the sum of given complex numbers.   Syntax   IMSUM(complex_num; [complex_num1]; ...) complex_num: Texts/ranges representing the complex numbers to add. E.g. "2+3j"   Examples   Formula Result =IMSUM("2+3j"; "1+2j") 3+5j =IMSUM("1-4i"; "5+1i") ...
• ## IMSUB

Returns the difference between two given complex numbers (i.e complex_num1- complex_num2).   Syntax   IMSUB(complex_num1; complex_num2) complex_num1: Text representing the first complex number. E.g. "2+3j" complex_num2: Text representing the second ...
• ## IMSQRT

Returns the square root of a complex number.   Syntax   IMSQRT(complex_number) complex_number: Text representing a complex number. E.g. "2+3j"   Examples   Formula Result =IMSQRT("2+3j") 1.67414922803554+0.895977476129838j =IMSQRT("1-4i") ...
• ## IMSIN

Returns the sine of a complex number.   Syntax   IMSIN(complex_number) complex_number: Text representing a complex number. E.g. "2+3j"   Examples   Formula Result =IMSIN("2+3j") 9.15449914691143-4.16890695996657j =IMSIN("1-4i") ...
• ## IMREAL

Returns the real coefficient of a given complex number.   Syntax   IMREAL(complex_number) complex_number: Text representing a complex number. E.g. "2+3j"   Examples   Formula Result =IMREAL("2+3j") 2 =IMREAL("1-4i") 1 =IMREAL("5j") 0 Get a hands-on ...
• ## IMPRODUCT

Returns the product of given complex numbers.   Syntax   IMPRODUCT(complex_num; [complex_num1]; ...) complex_num: Texts/ranges representing the complex numbers to multiply. E.g. "2+3j"   Examples   Formula Result =IMPRODUCT("2+3j"; "1+2j") -4+7j ...
• ## IMPOWER

Returns a complex number raised to the power of a given number.   Syntax   IMPOWER(complex_number; number) complex_number: Text representing a complex number. E.g. "2+3j" number: The number to which you want to raise the given complex number. E.g. 2 ...
• ## IMLOG2

Returns the base2 logarithm of a complex number.   Syntax   IMLOG2(complex_number) complex_number: Text representing a complex number. E.g. "2+3j"   Examples   Formula Result =IMLOG2("2+3j") 1.85021985907054+1.41787163074572j =IMLOG2("1-4i") ...
• ## IMLOG10

Returns the base10 logarithm of a complex number.   Syntax   IMLOG10(complex_number) complex_number: Text representing a complex number. E.g. "2+3j"   Examples    Formula Result =IMLOG10("2+3j") 0.556971676153418+0.426821890855467j =IMLOG10("1-4i") ...
• ## IMLN

Returns the natural logarithm of a complex number.   Syntax   IMLN(complex_number) complex_number: Text representing a complex number. E.g. "2+3j"   Examples   Formula Result =IMLN("2+3j") 1.28247467873077+0.982793723247329j =IMLN("1-4i") ...
• ## IMEXP

Returns e to the power of a complex number. For example, if complex_number is a+bi, it returns e(a+bi) = ea(cos b + isin b).   Syntax   IMEXP(complex_number) complex_number: Text representing a complex number. E.g. "2+3j"   Examples   Formula Result ...
• ## IMDIV

Returns the result of dividing one complex number by another.   Syntax   IMDIV(complex_num1; complex_num2) complex_num1: Text representing a (dividend) complex number. E.g. "2+3j" complex_num2: Text representing a (divisor) complex number. E.g. ...
• ## IMCOS

Returns the cosine of a complex number. For example, if complex_number is a+bi, it returns cos(a+bi) = cos(a)cosh(b) - sin(a)sinh(b)i.   Syntax   IMCOS(complex_number) complex_number: Text representing a complex number. E.g. "2+3j"   Examples   ...
• ## IMCONJUGATE

Returns the complex conjugate of a complex number. For example, if the given complex number is a+bi, it returns a-bi as text.   Syntax   IMCONJUGATE(complex_number) complex_number: Text representing a complex number. E.g. "2+3j"   Examples   Formula ...
• ## IMARGUMENT

Returns the argument of a complex number in radians. For a complex number a+bi = r(cosθ + isinθ), the argument is θ.   Syntax   IMARGUMENT(complex_number) complex_number: Text representing a complex number. E.g. "2+3j"   Examples   Formula Result ...
• ## IMAGINARY

Returns the imaginary coefficient of a given complex number.   Syntax   IMAGINARY(complex_number) complex_number: Text representing a complex number. E.g. "2+3j"   Examples   Formula Result =IMAGINARY("2+3j") 3 =IMAGINARY("1-4") -4 =IMAGINARY("5j") 5 ...
• ## IMABS

Returns the absolute value of a complex number.   Syntax   IMABS(complex_number) complex_number: Text representing a complex number. E.g. "2+3j"   Examples   Formula Result =IMABS("2+3j") 3.605551275 =IMABS("1-4i") 4.123105626 =IMABS("5j") 5 Get a ...
• ## COMPLEX

Returns a complex number in the form of a+bi or a+bj, given real and imaginary coefficients.   Syntax   COMPLEX(real; imaginary; [suffix]) real: The real coefficient of the complex number. E.g. 2 imaginary: The imaginary coefficient of the complex ...