IMREAL
Returns the real coefficient of a complex number in x+yi or x+yj text format. How to use
IMREAL
formula?  Examples of using
IMREAL
formula IMREAL
formula not working? Similar formulas to
IMREAL
Usage
Use the IMREAL
formula with the syntax shown below, it has 1 required parameter:
 complex_number (required):
The complex number to extract the real coefficient from. Must be in x+yi or x+yj text format.
Examples
Here are a few example use cases that explain how to use theIMREAL
formula in Google Sheets.
Extract real coefficient from complex number
Use IMREAL to extract the real coefficient from a complex number in x+yi or x+yj text format.
Calculate distance in 2D space
Use IMREAL to extract the xcoordinate from a complex number representing a point in 2D space. You can then use this value to calculate distances between points.
Calculate real component of AC voltage
Use IMREAL to calculate the real component of an AC voltage in a circuit. The complex number represents the voltage with both the real and imaginary components.
Common Mistakes
IMREAL
not working? Here are some common mistakes people make when using the IMREAL
Google Sheets Formula:
Providing a noncomplex argument
One common mistake when using the IMREAL
function is to provide a noncomplex argument. This will result in a #VALUE!
error. Make sure to provide a valid complex number as the argument.
Not using parentheses around complex number argument
When providing a complex number as an argument to the IMREAL
function, it is important to enclose the number in parentheses. Failing to do so will result in a #NAME?
error.
Related Formulas
The following functions are similar to IMREAL
or are often used with it in a formula:

IMAGINARY
The
IMAGINARY
function in Google Sheets returns the imaginary coefficient of a given complex number. The imaginary coefficient is the part of the complex number that is multiplied by the imaginary unit. This function is often used in engineering and scientific applications that involve complex numbers. 
COMPLEX
The
COMPLEX
function returns a complex number based on real and imaginary coefficients. It is commonly used in engineering calculations and signal processing.
Learn More
You can learn more about the IMREAL
Google Sheets function on Google Support.