Formualizer Docs
ReferenceFunctionsMath Functions

TAN

Returns the tangent of an angle in radians.

Summary

Returns the tangent of an angle in radians.

Remarks

  • Input is interpreted as radians.
  • Near odd multiples of PI()/2, results can become very large.

Examples

Tangent at PI/4
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
1
Tangent at zero
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0

FAQ

Why does TAN explode near PI()/2?

Because COS approaches zero there, TAN can become extremely large in magnitude.

Runtime metadata

Category

Math

Signature

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

SUMSQ

SUMSQ: Returns the sum of squares of supplied numbers.

TANH

TANH: Returns the hyperbolic tangent of a number.

On this page

SummaryRemarksExamplesRelated functionsFAQWhy does TAN explode near PI()/2?Runtime metadata