How to use the IMTAN Function in Excel office 365?
Tags: tousetheimtanfunctio, excel, excelfunctions
Published: 2021-08-27 10:53:15

---
title: How to use the IMTAN Function in Excel office 365?
published: true
date: 2021-08-25 18:43:27 UTC
tags: ToUseTheIMTANFunctio,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-imtan-function-in-excel-office-365/
---

The **IMTAN function** returns the **complex tangent of the complex number** having both **real & imaginary parts**. In this article, we are going to see how to  **use the IMTAN**  **Function In Excel Office 365.**  Let’s get into this article!! Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

## IMTAN Function Syntax

```
=IMTAN (inumber)
```

**Syntax Explanation:**

inumber: complex number having both real & imaginary.

## Example

- You have to **create a sample data** with values which will be **input** to the function.

![](https://geekexcel.com/wp-content/uploads/2021/08/Sample-data-32.png)<figcaption>Sample data</figcaption>

- Then, you need to get the **complex Sine** of the input **complex number**.
- Now, you have to use the following **formula** given below.

```
=IMTAN (A2)
```

**A2:** complex number (inumber) provided as a cell reference.

![](https://geekexcel.com/wp-content/uploads/2021/08/Use-IMTAN-formula-1024x438.png)<figcaption>Use IMTAN formula</figcaption>

- After that, the formula returns the **complex Sine of the complex number** using the following **formulation**.

```
Sin (4 + 3i) Sin (4) * Cosh (3) + i Cos (4) * Sinh (3)
Cos (4 + 3i) = Cos (4) * Cosh (3) - i Sin (4) * Sinh (3)
Tan (4 + 3i) = Sin (4 + 3i) / Cos (4 + 3i)

```

- Finally, you need to **copy the formula** to the **other remaining cells** using  **Ctrl + D**  shortcut key.

![](https://geekexcel.com/wp-content/uploads/2021/08/copy-to-other-celles-1024x430.png)<figcaption>Copy to other cells</figcaption>

**Check this too:**

- [IMSUM Function](https://geekexcel.com/how-to-use-imsum-function-in-ms-excel-365-with-examples/)
- [IMSUB Function](https://geekexcel.com/how-to-use-imsub-function-in-ms-excel-365-with-examples/)
- [IMABS Function](https://geekexcel.com/how-to-use-imabs-function-in-microsoft-excel-365/)

**NOTE:**

- The formula returns the **#NUM! error** if the complex number doesn’t have **lower case i or j ** (iota).
- The function returns the **#VALUE! Error** if the input argument to the function is a **logical value**.
- The input inumber or complex number must be in the **X + Yi text format**.

## Verdict

We hope that this short tutorial gives you guidelines to **use the IMTAN Function In Excel Office 365. ** Please leave a comment in case of any **queries,** and don’t forget to mention your valuable **suggestions** as well. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!! **Read more on [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Read Next:**

- **[How to Use IMSUB Function in MS Excel 365? – { With Examples }](https://geekexcel.com/how-to-use-imsub-function-in-ms-excel-365-with-examples/)**
- **[How to Use IMSUM Function in MS Excel 365? – (With Examples)](https://geekexcel.com/how-to-use-imsum-function-in-ms-excel-365-with-examples/)**
- **[How to Use IMPOWER Function in Excel 365? – [with Examples]](https://geekexcel.com/how-to-use-impower-function-in-excel-365-with-examples/)**
- **[How to Use IMPRODUCT Function in Excel 365? – [with Examples]](https://geekexcel.com/how-to-use-improduct-function-in-excel-365-with-examples/)**
- **[Excel Formulas to Test If a Cell Value is X and (Y or Z)!!](https://geekexcel.com/excel-formulas-to-test-if-a-cell-value-is-x-and-y-or-z/)**