ATAN2

Description

Returns the angle between the x-axis and a line segment from the origin (0,0) to specified coordinate pair (`x`,`y`), in radians.

Sample Usage

ATAN2(5,4)

ATAN2(A3)

Syntax

ATAN2(x,y)

• x - The x coordinate of the endpoint of the line segment for which to calculate the angle from the x-axis.

• y - The y coordinate of the endpoint of the line segment for which to calculate the angle from the x-axis.

Notes

• The DEGREES function can be used to convert the result of ATAN into degrees.

Step 1: To use the ATAN2 Formula, simply begin with your edited Excellentable:

Step 2: Then begin typing the ATAN2 formula in the area you would like to display the outcome: 

By adding the values you would like to calculate, Excellentable generates the outcome:

	A	B	C
1	State	Population	Total area in mi2	Land area in mi2	Water area in mi2
2	Alabama	4833722	52,420 (135,767)
3	Alaska	735132	665,384 (1,723,337)
4	Arizona	6626624	113,990 (295,233)
5	Arkansas	2959373	53,179 (137,733)
6	California	38332521	163,695 (423,968)
7	Colorado	5268367	104,094 (269,602)
8	Connecticut	3596080	5,543 (14,356)
9	Delaware	925749	2,489 (6,446)
10	Florida	19552860	65,758 (170,312)
11	Georgia	9992167	59,425 (153,910)
12	Hawaii	1404054	10,932 (28,314)
13	Idaho	1612136	83,569 (216,443)
14
15

	D	E	F
1

House seat(s)

50,645 (131,170)

1,775 (4,597)

7

570,641 (1,477,950)

94,743 (245,383)

1

113,594 (294,207)

396 (1,026)

9

52,035 (134,770)

1,143 (2,960)

4

155,779 (403,466)

7,916 (20,502)

53

103,642 (268,432)

452 (1,171)

7

4,842 (12,541)

701 (1,816)

5

1,949 (5,048)

540 (1,399)

1

53,625 (138,888)

12,133 (31,424)

27

57,513 (148,958)

1,912 (4,950)

14

6,423 (16,635)

4,509 (11,678)

2

82,643 (214,044)

926 (2,398)

2

ATAN2(x-coordinate, y-coordinate) in Radians:

See Also

TANH: Returns the hyperbolic tangent of any real number.

TAN: Returns the tangent of an angle provided in radians.

SINH: Returns the hyperbolic sine of any real number.

SIN: Returns the sine of an angle provided in radians.

RADIANS: Converts an angle value in degrees to radians.

PI: Returns the value of Pi to 14 decimal places.

DEGREES: Converts an angle value in radians to degrees.

COSH: Returns the hyperbolic cosine of any real number.

COS: Returns the cosine of an angle provided in radians.

ATANH: Returns the inverse hyperbolic tangent of a number.

ATAN: Returns the inverse tangent of a value, in radians.

ASINH: Returns the inverse hyperbolic sine of a number.

ASIN: Returns the inverse sine of a value, in radians.

ACOSH: Returns the inverse hyperbolic cosine of a number.

ACOS: Returns the inverse cosine of a value, in radians.