Quick Navigation

IMEXP Function

Excel 2007+

Summary

The Excel IMEXP function calculates the exponential (e^z) of a complex number z in the form x + yi. This engineering function is essential for advanced mathematical computations involving complex exponentials, commonly used in electrical engineering, signal processing, and physics.

Syntax

IMEXP(inumber)

Parameters

Parameter	Type	Required	Description
inumber	`Complex Number`	Yes	The complex number (as text) for which you want to compute the exponential. Use COMPLEX() function to create from real/imaginary parts.

Using the IMEXP Function

IMEXP computes e^(x+yi) = e^x * (cos(y) + i*sin(y)) following Euler's formula. Use it when working with complex exponentials in scientific applications, Fourier transforms, or AC circuit analysis.

Common IMEXP Examples

Basic Exponential Calculation

=IMEXP("1+i")

Calculates exponential of complex number 1+i, returns approximately 1.4687+2.2874i representing e^1*(cos(1)+i*sin(1))

Using COMPLEX Helper Function

=IMEXP(COMPLEX(2,3))

Exponential of 2+3i using COMPLEX to build the input

Frequently Asked Questions

Use text format like "3.5+2i" or "4-1.2j". Real part before + or -, imaginary coefficient before i or j.

Use COMPLEX(real_num, i_num) function to convert separate real and imaginary parts into complex format.

Common Errors and Solutions

#NUM! or #VALUE!

Cause: Invalid complex number format

Solution: Ensure correct format: real+imaginaryi. Use COMPLEX() helper.

#NAME?

Cause: IMEXP misspelled or unavailable

Solution: Verify spelling and Excel version (2007+)

Notes

Result follows Euler's formula: e^(x+yi) = e^x*(cos(y) + i*sin(y))
Any complex number can be expressed as exponential form
Use IMARGUMENT for phase angle, IMABS for magnitude

Compatibility

Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365

Not available in: Excel 2003 and earlier

Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+