Formualizer Docs
ReferenceFunctionsMath Functions

COT

Returns the cotangent of an angle, defined as `1 / TAN(angle)`.

Summary

COT is useful when working with reciprocal tangent relationships.

Remarks

  • Domain: valid for all real angles except where TAN(angle) = 0.
  • Radians: input is interpreted in radians.
  • Errors: returns #DIV/0! at or near integer multiples of PI().

Examples

Cotangent at PI over 4
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
1
Undefined cotangent at zero
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
#DIV/0!

FAQ

Why is COT undefined at integer multiples of PI()?

At those points TAN is zero, so 1/TAN triggers a #DIV/0! condition.

Runtime metadata

Category

Math

Signature

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

COSH

COSH: Returns the hyperbolic cosine of a number.

COTH

COTH: Returns the hyperbolic cotangent of a number, defined as `COSH(x) / SINH(x)`.

On this page

SummaryRemarksExamplesRelated functionsFAQWhy is COT undefined at integer multiples of PI()?Runtime metadata