Related Function:

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

Syntax

=IMEXP(inumber)

Arguments

Argument Description
inumber A complex number for which you want the exponential. The inumber argument can be supplied to the IMEXP function as either:

  a simple number 
  a complex number encased in quotation marks, e.g. “5+3i”
  a reference to a cell containing a complex number or a numeric value
  a value returned from another function or formula

Note: Use the COMPLEX function to convert real and imaginary coefficients into a complex number.

Examples

  A B C D
1 Data Formula Result Notes
2   =IMEXP(“1+i”) 1.46869393991589+2.28735528717884i Exponential of the complex number 1+i
3 2.5-i =IMEXP(A3) 6.58222957819277-10.2512151905294i  
4   =IMEXP(COMPLEX(1,-1)) 1.46869393991589-2.28735528717884i  
5   =IMEXP(2) 7.38905609893065  

Common Function Error(s)

Problem What went wrong
#NUM! Occurs if the supplied inumber argument is not recognized as a complex number
#NAME? Occurs when Analysis ToolPak add-in is not enabled

The exponential of a complex number is calculated by the following equation:

    \[ \label{eq:imexp}e^{(x+yi)}=e^xe^{yi}=e^x(cos\ y+i\ sin\ y)\]

Further information on Complex Numbers can be found on the Wikipedia Complex Numbers Page.