Functions
IMAGINARY
Imaginary part of a complex number
Try it
When to use it
When should I use IMAGINARY?
Use IMAGINARY to extract the imaginary part (the coefficient of i) from a complex number text string, for use in further arithmetic or display.
Used in
Syntax
IMAGINARY(complex)Examples
=IMAGINARY("3+5i") // => 5
=IMAGINARY("4j") // => 4
=IMAGINARY("45") // => 0