Excel like a finance pro.
← The libraryPractice · 2 questions →
Engineering function
IMEXP
Returns the exponential of a complex number.
Rarely usedDifficulty 1500 · AdvancedUsage rank #494 of 520
When to use it
e raised to a complex power.
The shape of it
- Syntax
=IMEXP(inumber)
Worked examples
Typical
=IMEXP("1+i") → 1.46869393991589+2.28735528717884i
A typical result.
Zero
=IMEXP("0") → 1
e to the zero.
Euler's formula
=IMEXP("i") → 0.54030230586814+0.841470984807897i
Euler: cos(1) + i sin(1).
Worth knowing
- IMEXP(COMPLEX(0,PI())) is -1, Euler's identity, to floating-point precision.
- IMLN is the inverse.
- Result is text.
Where it goes wrong
- #VALUE! for invalid text.
- Large real parts overflow.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.