How to Use Excel ATAN2 Function in Office 365? – {with Examples}
Tags: excelatan2functionin, excelfunctions
Published: 2020-08-31 12:27:23

---
title: How to Use Excel ATAN2 Function in Office 365? – {with Examples}
published: true
date: 2020-08-31 06:54:02 UTC
tags: ExcelATAN2Functionin,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-excel-atan2-function-in-office-365-with-examples/
---

## Excel ATAN2 Function:

![ATAN2 Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/5-15.png)<figcaption id="caption-attachment-12962">ATAN2 Function</figcaption>

This article describes the usage of **Excel ATAN2 Function in Office 365** with its syntax, description, and examples. 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)



## **ATAN2 Function – Description:**

- This function **returns the arctangent or inverse tangent from the specified x and y coordinates**.
- It returns the output in the **radian angle** according to its input.
- For example, the x and y coordinates are given in the following input format as **ATAN2(1,1)** and it returns the output as **0.7854-radian value.**

## **Syntax:**

**=ATAN2(x\_num, y\_num)**

### Argument Explanation:

**x\_num – ** The input x – axis value.

**y\_num – ** The input y – axis value.

- The **positive** output value refers to the **counterclockwise angle** (anti-clockwise) from the x – axis and the **negative** output refers to the **clockwise angle**.
- For example, the value of x and y is considered as **(1,1)** and then the arctangent value is **0.7854 radians**. As you see that the output value is positive and then the arc direction will be in a **counterclockwise** direction. Refer to the below image.

![Arc Tangent Graph Representation](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/Arc-Tangent.png)<figcaption id="caption-attachment-12979">Arc Tangent Graph Representation</figcaption>

**Image Source** : https://wumbo.net/

### Note:

- 
  - 
    - If both the arguments are zero, it returns **#DIV/0!** Error.
    - If any argument is a non-numeric value such as letters or special characters and then this function returns **#VALUE!** Error.

## **Examples:**

Let’s see some examples below.

### Example 1:

- 
  - 
    - The Excel ATAN2 function returns the arctangent in radians from the given x and y coordinates.
    - Kindly, refer to the below screenshot.
    - Here the  **positive** output value refers to the **counterclockwise angle** (anti-clockwise) from the x-axis and the **negative** output refers to the **clockwise angle**.
    - You can see the input **x-axis** values in **Column A** , **y-axis** values in **Column B** , and the output **radian** values are listed in **Column C**.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/1-98.png)<figcaption id="caption-attachment-12952">Example 1</figcaption>

### Example 2:

- 
  - 
    - If both the arguments are zero, it returns **#DIV/0!** Error.
    - If any argument is a non-numeric value such as letters or special characters and then this function returns **#VALUE!** Error.

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/4-20.png)<figcaption id="caption-attachment-12955">Example 2</figcaption>

### Example 3:

- 
  - 
    - If you want to convert the radians to degrees, use the following formulas.

**=ATAN2(x,y)\*180/PI()** or **=DEGREES(ATAN2(x,y))**

![Example 3](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/3-53.png)<figcaption id="caption-attachment-12954">Example 3</figcaption>

### Difference Between ATAN and ATAN2 Function:

- 
  - 
    - The relationship between the [**ATAN**](https://geekexcel.com/how-to-use-excel-atan-function-in-office-365-with-examples/)and **ATAN2** functions is described in the below formula. Both functions return the identical output values.

**=ATAN2(x, y) =ATAN(y/x)**

## **Closure:**

In the above article, you can understand the usage of **Excel ATAN2 Function in Office 365** with its syntax, description, and examples. Share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!