# IMREAL

Returns the real coefficient of a complex number in x+yi or x+yj text format.

## Usage

Use the `IMREAL` formula with the syntax shown below, it has 1 required parameter:

Parameters:
1. 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 the `IMREAL` 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 x-coordinate 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 non-complex argument

One common mistake when using the `IMREAL` function is to provide a non-complex 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.

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.

You can learn more about the `IMREAL` Google Sheets function on Google Support.