September 23, 2023

How to use IMAGINARY Function in Excel

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:

IMAGINARY Function - How to use IMAGINARY Function in Excel

Syntax:  =IMAGINARY(A2)

Result:

IMAGINARY Function in Excel - How to use IMAGINARY Function in Excel

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.

READ:  How to use OCT2DEC Function in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *