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 ...