IMAGINARYReturns 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