Microsoft Excel is a spreadsheet-based software utility that helps to perform various mathematical calculations. You can also use shortcuts to access the Excel features. Excel also provides Macros and VBA features to automate tasks and complete them as quickly as possible. You can also use the Excel functions to achieve the task as quickly and effectively as possible.
The ATAN2 function returns the inverse tangent from the specified x and y coordinates. This article describes the usage of Excel ATAN2 Function with its syntax, description, and examples. Get an official version of MS Excel from the following link:
Description of ATAN2 Function
- It is one of the built-in functions in Microsoft Excel.
- 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 a 0.7854-radian value.
- Here, you will see the syntax of the ATAN2 function.
- To apply this function on your spreadsheet, you have to select a cell and enter the formula in the following format.
- Once you enter the formula, just click on the Enter button to get the result.
- 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 a counterclockwise direction. Refer to the below image.
Image Source: https://wumbo.net/
1) If both the arguments are zero, it returns #DIV/0! Error.
2) If any argument is a non-numeric value such as letters or special characters and then this function returns #VALUE! Error.
Here, we come up with some examples to know how to use the ATAN2 function in the Excel spreadsheet.
- Initially, you have to open your Excel workbook on your PC and launch a worksheet that has data.
- You can see the input x-axis values in Column A, the y-axis values in Column B, and the output radian values will be listed in Column D.
- 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.
- Then, you have to enter the formula in the cell as shown below to get the result.
- After entering the formula, you need to click the Enter button to get the output, as shown below. You can drag down the cell to fill the remaining cells.
Input that Causes Error
- 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.
Difference Between ATAN and ATAN2 Function
- The relationship between the ATAN and ATAN2 functions is described in the below formula. Both functions return identical output values.
=ATAN2(x, y) =ATAN(y/x)
In the above article, you can understand the usage of Excel ATAN2 Function with its syntax, description, and examples. Share your feedback in the comment section. To learn more about Excel functions, then visit our webpage Aawexcel.com.
The following video will show you how to apply the ATAN2 function in the spreadsheet.
- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?
Hi there, I’m Sridhar – an Excel enthusiast with over 10 years of experience working with software. I’m passionate about using Excel to solve complex problems and streamline business processes. Over the years, I have helped businesses of all sizes to improve their operations and save time and money.
Aside from working with Excel, I also enjoy writing and sharing my knowledge with others. You’ll often find me contributing to the AAW Excel blog, where I provide tips, tricks, and tutorials that are easy to understand for readers of all skill levels.