Related Functions:

The IMTAN function returns the tangent of a complex number in x+yi or x+yj text format.

  • This function was introduced in Excel 2013 and so is not available in earlier versions.




Argument Description
inumber A complex number for which you want the tangent

Note: Use the COMPLEX function to convert real and imaginary coefficients into a complex number.


  A B C D
1 Data Formula Result Notes
2 3+4i =IMTAN(A2) -0.000187346204629478+0.999355987381473i Returns the tangent of a complex number
3   =IMTAN(“3+4i”) -0.000187346204629478+0.999355987381473i  
4   =IMTAN(“2-i”) -0.243458201185725-1.16673625724092i  
5   =IMTAN(COMPLEX(4,1)) 0.273553082807307+1.0028105075835i  

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if the supplied inumber argument is a logical value
#NUM! Occurs if the supplied inumber argument is not recognized as a complex number

The tangent of a complex number is calculated as follows:   

    \[   tan(z) = \frac{sin(z)}{cos(z)}    \]

See Wikipedia for more information on complex numbers.