Returns the real coefficient of a complex number in x + yi or x + yj text format.
Cú pháp
IMREAL(inumber)Đối số
inumberbắt buộc
A complex number for which you want the real coefficient.
The IMREAL function extracts the real part of a complex number. The input must be a string formatted as either 'x+yi' or 'x+yj', where x is the real coefficient and y is the imaginary coefficient.
=IMREAL("3+4i")→3Extracts the real part 3 from the complex number 3+4i.
=IMREAL("-5-2j")→-5Extracts the real part -5 from the complex number -5-2j.
Select a cell
Click on the cell where you want to display the real part of the complex number.
Enter the formula
Type =IMREAL("x+yi") replacing x+yi with your specific complex number or a cell reference.
Excel will return the #NUM! error value.