ReferenceFunctionsMath Functions
ATAN2
ATAN2: Returns the arctangent of `y/x`, preserving quadrant information.
Summary
Returns the arctangent of y/x, preserving quadrant information.
Remarks
- Formualizer uses Excel-style argument order:
ATAN2(x_num, y_num). - Returns
#DIV/0!when both arguments are zero.
Examples
First quadrant angle
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
0.7853981633974483
Undefined angle at origin
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
#DIV/0!
Related functions
FAQ
Why does ATAN2 return #DIV/0! at (0,0)?
The origin has no defined direction angle, so ATAN2 reports #DIV/0!.
Runtime metadata
Category
Math
Signature
ATAN2(arg1: Number, arg2: Number)Arity
min 2, max 2
Arguments
arg1Number · Scalar · coercion NumberLenientText
arg2Number · Scalar · coercion NumberLenientText
Caps
PUREELEMENTWISENUMERIC_ONLY
Source