The IMREAL function returns the real coefficient of a complex number in x + yi or x + yj text format.
|inumber||A complex number for which you want the imaginary coefficient. The inumber argument can be supplied to the IMREAL function as either:
Note: Use the COMPLEX function to convert real and imaginary coefficients into a complex number.
|2||6-9i||=IMREAL(A2)||6||Real coefficient of 6-9i|
Common Function Error(s)
|Problem||What went wrong|
|#NUM!||Occurs if the supplied inumber argument is not recognized as a complex number|
|#NAME?||Occurs when Analysis ToolPak add-in is not enabled|
Within the real number scale, there is no such thing as the square root of a negative number. However, within the world of complex numbers, the ‘imaginary’ value, i is used to represent the square root of -1.
Therefore, the square root of any negative number can be represented by the square root of the number’s modulus, multiplied by i.