Formulas and Functions
Table Of Contents
- Formulas and Functions
- Contents
- Preface: Welcome to iWork Formulas & Functions
- Chapter 1: Using Formulas in Tables
- The Elements of Formulas
- Performing Instant Calculations in Numbers
- Using Predefined Quick Formulas
- Creating Your Own Formulas
- Removing Formulas
- Referring to Cells in Formulas
- Using Operators in Formulas
- The String Operator and the Wildcards
- Copying or Moving Formulas and Their Computed Values
- Viewing All Formulas in a Spreadsheet
- Finding and Replacing Formula Elements
- Chapter 2: Overview of the iWork Functions
- Chapter 3: Date and Time Functions
- Chapter 4: Duration Functions
- Chapter 5: Engineering Functions
- Chapter 6: Financial Functions
- Chapter 7: Logical and Information Functions
- Chapter 8: Numeric Functions
- Chapter 9: Reference Functions
- Chapter 10: Statistical Functions
- Listing of Statistical Functions
- AVEDEV
- AVERAGE
- AVERAGEA
- AVERAGEIF
- AVERAGEIFS
- BETADIST
- BETAINV
- BINOMDIST
- CHIDIST
- CHIINV
- CHITEST
- CONFIDENCE
- CORREL
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUNTIFS
- COVAR
- CRITBINOM
- DEVSQ
- EXPONDIST
- FDIST
- FINV
- FORECAST
- FREQUENCY
- GAMMADIST
- GAMMAINV
- GAMMALN
- GEOMEAN
- HARMEAN
- INTERCEPT
- LARGE
- LINEST
- Additional Statistics
- LOGINV
- LOGNORMDIST
- MAX
- MAXA
- MEDIAN
- MIN
- MINA
- MODE
- NEGBINOMDIST
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- PERCENTILE
- PERCENTRANK
- PERMUT
- POISSON
- PROB
- QUARTILE
- RANK
- SLOPE
- SMALL
- STANDARDIZE
- STDEV
- STDEVA
- STDEVP
- STDEVPA
- TDIST
- TINV
- TTEST
- VAR
- VARA
- VARP
- VARPA
- ZTEST
- Chapter 11: Text Functions
- Chapter 12: Trigonometric Functions
- Chapter 13: Additional Examples and Topics
- Index
Chapter 12 Trigonometric Functions 331
“DEGREES” on page 334
“TAN” on page 338
“TANH” on page 339
“Listing of Trigonometric Functions” on page 326
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
ATAN2
The ATAN2 function returns the angle, relative to the positive x-axis, of the line passing
through the origin and the specied point.
ATAN2(x-point, y-point)
 x-point: The x-coordinate of the point the line passes through. x-point is a number
value.
 y-point: The y-coordinate of the point the line passes through. y-point is a number
value.
Usage Notes
The angle is expressed in radians, in the range –pi through +pi. To see the resulting Â
angle in degrees instead of radians, wrap this function in the DEGREES function; that
is, =DEGREES(ATAN2(x-point, y-point)).
Examples
=ATAN2(1, 1) returns 0.78539816 radians (45 degrees), the angle of a line segment from the origin to
point (1, 1).
=DEGREES(ATAN2(5, 5)) returns 45.
Related Topics
For related functions and additional information, see:
“ATAN” on page 330
“ATANH” on page 332
“DEGREES” on page 334
“TAN” on page 338










