Search results
There are two functions for calculating the inverse tangent or arctan in Excel. These two functions are ATAN and ATAN2 (“atan” is short for arctangent), and they each have specific uses depending on the desired results that you’d like to obtain and the inputs available.
Returns the arctangent, or inverse tangent, of a number. The arctangent is the angle whose tangent is number. The returned angle is given in radians in the range -pi/2 to pi/2. To express the arctangent in degrees, multiply the result by 180/PI( ) or use the DEGREES function.
The Excel ATAN function returns the inverse tangent or arc-tangent of a number. In geometric terms, the function returns the angle of a right-triangle given the ratio of its opposite side over its adjacent side. The ATAN function is the inverse of the TAN function.
Returns the arctangent, or inverse tangent, of the specified x- and y-coordinates. The arctangent is the angle from the x-axis to a line containing the origin (0, 0) and a point with coordinates (x_num, y_num). The angle is given in radians between -pi and pi, excluding -pi.
17 lut 2021 · In this simple guide, we are going to run through how to use the Excel ATAN function to calculate the inverse tangent of a given number.
The Microsoft Excel ATAN function returns the arctangent (in radians) of a number. The ATAN function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function (WS) in Excel.
The Excel ATAN function calculates the arctangent (i.e. the inverse tangent) of a given number, and returns an angle, in radians, between -π/2 and +π/2. The syntax of the function is: ATAN( number )
