IMREAL

Formulas / IMREAL
Calculate 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.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV