This article describes the formula syntax and usage of the IMTAN function (function: A prewritten formula that takes a value or values, performs an operation, and returns a value or values. Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.) in Microsoft Excel.
Returns the tangent of a complex number in x+yi or x+yj text format.
The IMTAN function syntax has the following arguments.
- Inumber Required. A complex number for which you want the tangent.
- Use COMPLEX to convert real and imaginary coefficients into a complex number.
- If inumber is a value that is not in the x+yi or x+yj text format, IMTAN returns the #NUM! error value.
- If inumber is a logical value, IMTAN returns the #VALUE! error value.
The workbook below shows examples of this function. Inspect them, change existing formulas, or enter your own formulas to learn how the function works.
To work more in-depth with the example data in Excel, download the embedded workbook to your computer, and then open it in Excel.
Top of Page