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 output along the real axis forms the shape of the regular (circular)tangent function.

Complex tangent definition.

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

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

TANH Function

The Excel TANH function returns the hyperbolic tangent of a number.

Complex tangent definition.

IMCOS Function

The Excel IMCOS function returns the cosine of a complex number.

IMSIN Function

The Excel IMSIN function returns the sine of a complex number.

COMPLEX Function

The Excel COMPLEX function returns the string representation of a complex number.

Complex tangent definition.

Complex tangent definition.

Complex tangent definition.

Real output of the complex tangent function.

Real output of the complex tangent function highlight regular tangent.

Imaginary output of the complex tangent function.

Imaginary output of the complex tangent function highlight hyperbolic tangent.

Excel TAN function

Excel TANH function

Excel IMCOS function

Excel IMSIN function

Excel COMPLEX function

Real output of the complex tangent function.

Real output of the complex tangent function highlight regular tangent.

Imaginary output of the complex tangent function.

Imaginary output of the complex tangent function highlight hyperbolic tangent.