The Excel IMAGINARY function returns the imaginary coefficient of a complex number given in the form x + yi or x + yj
Syntax: =IMAGINARY (inumber)
The IMAGINARY function syntax has the following arguments:
- Inumber Required. A complex number for which you want the imaginary coefficient
Example: Let’s look at some Excel IMAGINARY function examples and explore how to use the IMAGINARY function as a worksheet function in Microsoft Excel:
Syntax: =IMAGINARY(A2)
Result:
Based on the Excel spreadsheet above, the following IMAGINARY examples would return:
Syntax: =IMAGINARY(A3)
Result: 4
Syntax: =IMAGINARY(A4)
Result: 0
Syntax: =IMAGINARY(A5)
Result: 8
Syntax: =IMAGINARY(A6)
Result: 12
Syntax: =IMAGINARY(A7)
Result: -1
Syntax: =IMAGINARY(A8)
Result: -6
Syntax: =IMAGINARY(A9)
Result: 2
Syntax: =IMAGINARY(A10)
Result: -3
Syntax: =IMAGINARY(A11)
Result: -12
Syntax: =IMAGINARY(A12)
Result: -30
Syntax: =IMAGINARY(A13)
Result: 4
Note: Only lowercase “j” and “i” are accepted by IMAGINARY. Other values will result in the #NUM error.