Author: Oscar Cronquist Article last updated on November 10, 2022

How to use the IMEXP function

The IMEXP function calculates the exponential of a complex number in x + yi or x + yj text format.

The letter j is used in electrical engineering to distinguish between the imaginary value and the electric current.

The exponential of a complex number is calculated like this:

C = x + yi

IMEXP(C) = e(x+yi) = exeyi = ex(cos y + isin y)

1. IMEXP Function Syntax

IMEXP(inumber)

Back to top

2. IMEXP Function Arguments

inumber Required. A complex number in x+yi or x+yj text format.

Back to top

3. IMEXP function example

How to use the IMEXP function

The image above demonstrates a formula in cell D3 that calculates the exponential of a complex number specified in cell C3.

Formula in cell D3:

=IMEXP(C3)

3.1 Explaining formula

Step 1 - Populate arguments

IMEXP(inumber)

becomes

IMEXP(C3)

Step 2 - Evaluate the IMEXP function

IMEXP(C3)

becomes

IMEXP("1+2i")

and returns

-1.13120438375681+2.47172667200482i

Back to top