Formualizer Docs
ReferenceFunctionsMath Functions

SEC

Returns the secant of an angle, defined as `1 / COS(angle)`.

Summary

Use SEC for reciprocal-cosine calculations in radian-based formulas.

Remarks

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

Examples

Secant at zero
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
1
Singularity at PI over 2
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
#DIV/0!

FAQ

When does SEC return #DIV/0!?

SEC returns #DIV/0! when COS(angle) is effectively zero.

Runtime metadata

Category

Math

Signature

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

ROUNDUP

ROUNDUP: Rounds a number away from zero to a specified number of digits.

SECH

SECH: Returns the hyperbolic secant of a number, defined as `1 / COSH(x)`.

On this page

SummaryRemarksExamplesRelated functionsFAQWhen does SEC return #DIV/0!?Runtime metadata