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.