Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

IMTAN function

Returns the tangent of a complex number. The tangent of a complex number can be expressed by:

IMTAN equation

The result is presented in the string format and has the character "i" or "j" as an imaginary unit.

This function is part of the Open Document Format for Office Applications (OpenDocument) standard Version 1.2. (ISO/IEC 26300:2-2015)

This function is available since Office 3.6.

Syntax

IMTAN(Complex-number)

Complex-number is a complex number whose tangent is to be calculated.

A complex number is a string expression resulting in the form "a+bi" or "a+bj", where a and b are numbers.

If the complex number is actually a real number (b=0), then it can be either a string expression or a number value.

The function always returns a string representing a complex number.

If the result is a complex number with one of its parts (a or b) equal to zero, that part is not displayed.

Examples

=IMTAN("4-3i")
returns 0.00490825806749606-1.00070953606723i.

=IMTAN(2)
returns -2.18503986326152 as a string. The imaginary part is equal to zero, so it is not displayed in the result.

Open file with example: