Formualizer Docs
ReferenceFunctionsMath Functions

ACOS

ACOS: Returns the angle in radians whose cosine is the input value.

Summary

Use ACOS when you need an angle from a normalized adjacent/hypotenuse ratio.

Remarks

  • Domain: input must be between -1 and 1, inclusive.
  • Radians: output is in the range [0, PI()].
  • Errors: returns #NUM! when the input is outside the valid domain.

Examples

Arccosine of one half
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
1.0471975511965979
Upper-angle boundary
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
3.141592653589793

FAQ

Why does ACOS reject values like 1.0001?

ACOS is only defined on [-1, 1], so out-of-range inputs return #NUM!.

Runtime metadata

Category

Math

Signature

ACOS(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

ABS

Returns the absolute value of a number.

ACOSH

ACOSH: Returns the inverse hyperbolic cosine of a number.

On this page

SummaryRemarksExamplesRelated functionsFAQWhy does ACOS reject values like 1.0001?Runtime metadata