Returns the imaginary coefficient of a complex number.

Sample Usage

IMAGINARY("4+5i")

IMAGINARY("2j")

Syntax

IMAGINARY(complex_number)

  • complex_number - The complex number, in the a+bi or a+bj format.

See also

  • COMPLEX: The COMPLEX function creates a complex number, given real and imaginary coefficients.
  • IMREAL: Returns the real coefficient of a complex number.

Examples

2FormulaResult
3=IMAGINARY("3+5i")5
4=IMAGINARY("4j")4
5=IMAGINARY("45")0