IMEXP Function in Excel returns the exponential of a supplied complex number.
The exponential of a complex number z = x + iy is calculated by the equation,
e(x+iy) = exeyi = ex(cos y + i sin y)
Syntax of IMEXP Function in Excel
IMEXP( inumber )
Where inumber argument is a Complex Number.
Example of IMEXP Function in Excel
Formula
- From Row number 2 to 5 IMEXP Function takes up complex number as a reference
- In row number 6 IMEXP Function takes up complex number(imaginary component) as a value which should be enclosed in double quotes
- In row number 7 IMEXP Function takes up real component as a value.
Result
NOTE: #NUM! – Error occurs if,
- supplied inumber argument is not recognized as a complex number.