IMEXP function

The IMEXP function in Excel returns the exponential of a given complex number. The exponential of a complex number is based on the formula for the exponential function, which can be extended to complex numbers.

Syntax

IMEXP(inumber)

Parameters

• inumber: The complex number for which you want to calculate the exponential. The complex number can be entered as a string in the form a + bi or a + bj, where a is the real part and b is the imaginary part.

How It Works

For a complex number z = a + bi, the exponential is calculated using Euler’s formula:

$$e^{z} = e^{a} \cdot (\cos(b) + i\sin(b))$$

Where:

• 
  $e^{a}$ 

  is the exponential of the real part a

• 
  $\cos(b)$ 

  and $\sin(b)$ 

  are the trigonometric functions applied to the imaginary part b

Examples

1. Exponential of a Complex Number: To calculate the exponential of the complex number 2 + 3i:

   =IMEXP("2+3i")
   

   The result will be approximately -7.3151100949011 + 1.0427436562359i.

2. Exponential of a Real Number: If you use a real number like 2 (no imaginary part):

   =IMEXP(2)
   

   The result will be 7.38905609893065, which is the exponential of 2.

3. Exponential of a Purely Imaginary Number: To calculate the exponential of a purely imaginary number such as 0 + 3i:

   =IMEXP("0+3i")
   

   The result will be approximately -0.98999249660045 + 0.14112000805987i.

4. Using a Cell Reference: If cell A1 contains the complex number "1+4i", you can calculate the exponential using:

   =IMEXP(A1)
   

   The result will be approximately -0.41976401783986 - 0.90795510835814i.

Important Notes

• The IMEXP function works only with valid complex numbers. If the input is not a valid complex number, Excel will return a #VALUE! error.
• For real numbers, the IMEXP function behaves like the standard exponential function.
• Complex numbers in Excel can be represented using either i or j for the imaginary part.

Summary

The IMEXP function in Excel calculates the exponential of a complex number. It is commonly used in mathematical, engineering, and scientific applications where complex number calculations are required.