The IMTAN function returns the tangent of a complex number in x + yi or x + yj text format. The tangent of a complex number is calculated by the following formula:
Syntax:= IMTAN (inumber)
The IMTAN function syntax has the following arguments:
- Inumber: Required. A complex number for which you want the tangent
Example: Let’s look at some Excel IMTAN function examples and explore how to use the IMTAN function as a worksheet function in Microsoft Excel:
Based on the Excel spreadsheet above, the following IMTAN examples would return:
- 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.