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.