IMREAL
Formulas / IMREALCalculate the real coefficient of a complex number.
IMREAL(inumber)
- inumber - a complex number that is required
Examples
=IMREAL("6-9i")TheIMREAL> function is used to extract the real part of a complex number. For example the formula above, which will return 6.
=IMREAL(A1)The IMREAL function can also be used with a cell reference. For example, if cell A1 contains a complex number, the formula will return 3.
=IMREAL(A1, A2)The IMREAL function can also be used with multiple complex numbers. For example, if cell A1 contains a complex number and cell A2 contains a complex number, the formula will return 2 and 4 respectively.
Summary
IMREAL is a function which takes a complex number as input and returns its real part. The complex number must be formatted as x + yi or x + yj.
- The IMREAL function takes a complex number as its argument and returns the real part of that number.
- The complex number is formatted in the syntax of x + yi or x + yj.
Frequently Asked Questions
What is the IMREAL function?
The IMREAL function is a mathematical tool used to return the real part of a complex number. It takes a complex number as its argument and returns a complex number that is a real number.
What is the output of IMREAL?
The IMREAL function returns a complex number that is a real number.
Can IMREAL convert real and imaginary coefficients into a complex number?
No, but the COMPLEX function can be used to convert real and imaginary coefficients into a complex number.
What is a complex number?
A complex number is a number that consists of a real and an imaginary part. The real part is a number that consists of a coefficient and an exponent, and the imaginary part consists of a coefficient and an imaginary unit.
How do I use the IMREAL function?
To use the IMREAL function, you need to pass a complex number as an argument to the function. The function will then return a complex number that is a real number.
