IMAGINARY Function in Google Sheets

Extract the imaginary part of a complex number using the IMAGINARY function.

IMAGINARY Function

The IMAGINARY function in Google Sheets extracts the imaginary part of a complex number.

Syntax

IMAGINARY(complex_number)
  • complex_number: The complex number from which you want to extract the imaginary part. This is a required parameter.

Examples

  1. Extracting the Imaginary Part

Extract the imaginary part of the complex number ‘3+4i’:

=IMAGINARY("3+4i")

This will output 4.

  1. Imaginary Part of a Purely Imaginary Number

Extract the imaginary part of the complex number ‘0+5i’:

=IMAGINARY("0+5i")

This will output 5.

  1. Imaginary Part of a Real Number

Extract the imaginary part of the number ‘7’:

=IMAGINARY("7")

This will output 0.

Notes

  • The IMAGINARY function is useful in calculations involving the manipulation of complex numbers.
  • The imaginary part of a complex number is the coefficient of the imaginary unit (i) in the complex number.
  • IMABS: Calculate the absolute value of a complex number.
  • IMREAL: Extract the real part of a complex number.