Summary

The Excel IMTAN function returns the tangent of a complex number.

Purpose
Get the tangent of a complex number.
Return value
Returns the tangent of the complex number.
Syntax
=IMTAN(complex_num)
  • complex_num - The complex number in the form "x+yi".

Using the IMTAN function

The Excel IMTAN function returns the tangent of a complex number. For example, given the complex number "3+4i" as input, the function returns "-0.000187346+0.999355987i"

=IMTAN("3+4i") // returns -0.000187346+0.999355987i

Explanation

In math, the tangent of a complex number is defined in terms of complex sine and cosine functions.

Complex tangent definition.

In Excel, the tangent of a complex number is equivalent to the following formula.

=IMDIV(IMSIN(z),IMCOS(z)) // equivalent to IMTAN(z)

The 3D plot below visualizes the function's real output. The horizontal XY plane represents input from the complex plane, and the vertical axis represents the function's real output.

Real output of the complex tangent function.

The output along the real axis forms the shape of the regular (circular) tangent function.

Real output of the complex tangent function highlight regular tangent.

The imaginary output of the function is visualized by the 3D plot below.

Imaginary output of the complex tangent function.

The output along the imaginary axis forms the shape of the hyperbolic tangent function.

Imaginary output of the complex tangent function highlight hyperbolic tangent.

Support Exceljet

Many websites (including Exceljet) have lost over half their traffic in the past year because of the crushing impact of AI on web searches. Exceljet is still at it, publishing free content each week. If you find Exceljet helpful, you can support the site and go ad-free with the Exceljet Lifetime Pass. One payment, no subscription, and ads are gone forever. Plus, you get our Excel Shortcuts video course as a thank you.

Get the Lifetime Pass

Dave Bruns Profile Picture

AuthorMicrosoft Most Valuable Professional Award

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.