IMPRODUCT Function
The Excel IMPRODUCT function returns the product of one or more complex numbers. For example:
=IMPRODUCT("1+2i", "3+5i") // returns -7+11iExcel handles complex numbers as strings formatted
...Read more
Dave Bruns
IMDIV Function
The Excel IMDIV function returns the quotient of two complex numbers. For example, given "-7+11i" and "3+5i" as input, the function returns the quotient "1+2i", which is the result of dividing the first number by the second.
=IMDIV(COMPLEX(-7,11),...Read moreIMSQRT 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
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