IMAGINARY

IMAGINARY

Synopsis

IMAGINARY(inumber)

Description

IMAGINARY returns the imaginary part of a complex number.

  • If inumber is not a valid complex number, IMAGINARY returns #VALUE! error.
  • This function is Excel compatible.

Examples

IMAGINARY("132-j") equals -1.

See also

IMREAL.