IMAGINARY

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

1 A B
2 Formula Result
3 =IMAGINARY("3+5i") 5
4 =IMAGINARY("4j") 4
5 =IMAGINARY("45") 0
Was this article helpful?
How can we improve it?