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:
Based on the Excel spreadsheet above, the following IMAGINARY examples would return:
Note: Only lowercase “j” and “i” are accepted by IMAGINARY. Other values will result in the #NUM error.