IMEXP Function in Excel – Get the exponential of a complex number

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

IMEXP Function in Excel 1

  • 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

IMEXP Function in Excel 2

NOTE: #NUM! – Error occurs if,

  • supplied inumber argument is not recognized as a complex number.

previous-small IMEXP Function in Excel                                                                                                           next_small IMEXP Function in Excel