IMREAL Function in Google Sheets

Extract the real part of a complex number using the IMREAL function.

IMREAL Function

The IMREAL function in Google Sheets returns the real part of a complex number.

Syntax

IMREAL(complex_number)
  • complex_number: The complex number from which to extract the real part. This is a required parameter.

Examples

  1. Basic Usage

Extract the real part of the complex number 5+4i:

=IMREAL("5+4i")

This will output 5.

Notes

  • The complex number can be provided as a string, e.g., ā€œ5+4iā€.
  • The function works with any valid complex number format.
  • IMAGINARY: Extract the imaginary part of a complex number.
  • IMCONJUGATE: Return the complex conjugate of a complex number.