IMSQRT Function
The Excel IMSQRT function returns the square root of a complex number. For example:
=IMSQRT("3+4i") // returns "2+i"Excel handles complex numbers as strings formatted like "x+yi" or "x+yj".
...Read more
Dave Bruns
IMSUM Function
The Excel IMSUM function returns the sum of two or more complex numbers. For example:
=IMSUM("4+3i","2-5i") // returns "6-2i"Excel handles complex numbers as strings formatted
...Read more
IMSUB Function
The IMSUB function returns the difference between two complex numbers. For example:
=IMSUB("4+3i","1+2i") // returns "3+i"Excel handles complex numbers as strings formatted like "x+yi" or "x
...Read more
IMCONJUGATE Function
The Excel IMCONJUGATE function returns the conjugate of a complex number. For example, given the complex number "3+4i" as input, the function returns "3-4i" as output.
=IMCONJUGATE("3+4i") // returns "3-4i"
...Read more
IMARGUMENT Function
The Excel IMARGUMENT function returns the angle of a complex number measured in radians. For example, given the complex number "3+4i" the function returns the angle 0.927295218.
=IMARGUMENT("3+4i") // returns 0.927295218
...Read moreIMABS Function
The Excel IMABS function returns the absolute value of a complex number. For example:
=IMABS("4+3i") // returns 5
Excel handles complex numbers as strings formatted like "x+yi" or "x+yj". Use the
...Read more
IMAGINARY Function
The Excel IMAGINARY function returns the imaginary part of a complex number. For example:
=IMAGINARY("4+3i") // returns 3
Excel handles complex numbers as strings formatted like "x+yi" or "x+yj". Use the
...Read more
IMREAL Function
The IMREAL function returns the real part of a complex number. For example:
=IMREAL("4+3i") // returns 4
Excel handles complex numbers as strings formatted like "x+yi" or "x+yj". Use the
...Read more
ACOTH Function
The Excel ACOTH function returns the inverse hyperbolic cotangent of a number. Given 2 as input, the function returns 0.549306144 as output.
=ACOTH(2) // returns 0.549306144
Explanation
The hyperbolic arc cotangent function...Read more
IMSECH Function
The Excel IMSECH function returns the hyperbolic secant of a complex number. Given "1+1.5707963267949i" as input, the function returns "-3.9E-15-0.85092i" as output.
=IMSECH(COMPLEX(1, PI()/2)) // returns -3.9E-15-0.85092i