Formualizer Docs
ReferenceFunctionsMath Functions

ATAN

ATAN: Returns the angle in radians whose tangent is the input value.

Summary

ATAN is useful for recovering a slope angle from a ratio.

Remarks

  • Domain: accepts any real number.
  • Radians: output is in the range (-PI()/2, PI()/2).
  • Errors: no function-specific domain errors are produced.

Examples

Arctangent of one
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.7853981633974483
Negative slope angle
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
-0.7853981633974483

FAQ

Does ATAN ever return #NUM! for large values?

No. ATAN accepts any real input and asymptotically approaches +/-PI()/2.

Runtime metadata

Category

Math

Signature

ATAN(arg1: Number)

Arity

min 1, max 1

Arguments

arg1

Number · Scalar · coercion NumberLenientText

Caps

PUREELEMENTWISENUMERIC_ONLY

Source

crates/formualizer-eval/src/builtins/math/trig.rs

ASINH

ASINH: Returns the inverse hyperbolic sine of a number.

ATAN2

ATAN2: Returns the arctangent of `y/x`, preserving quadrant information.

On this page

SummaryRemarksExamplesRelated functionsFAQDoes ATAN ever return #NUM! for large values?Runtime metadata