ID EN
#Engineering

IMTAN

Excel Functions

Get the tangent of a complex number.

Syntax

EXCEL
=IMTAN(complex_num)

Arguments

Parameter Description
complex_num The complex number in the form "x+yi".

Return Value

Returns the tangent of the complex number.

Details

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" In math, the tangent of a complex number is defined in terms of complex sine and cosine functions. In Excel, the tangent of a complex number is equivalent to the following formula. 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. The output along the real axis forms the shape of the regular (circular) tangent function.

Examples

Example 1

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.0001

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

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

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

See Also

TAN TANH IMCOS IMSIN COMPLEX