Formualizer Docs
ReferenceFunctionsMath Functions

CSC

CSC: Returns the cosecant of an angle, defined as `1 / SIN(angle)`.

Summary

Use CSC for reciprocal-sine calculations in radian-based formulas.

Remarks

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

Examples

Cosecant at PI over 2
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
1
Zero sine denominator
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
#DIV/0!

FAQ

When does CSC return #DIV/0!?

CSC returns #DIV/0! when SIN(angle) is effectively zero.

Runtime metadata

Category

Math

Signature

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

COUNTIFS

COUNTIFS: Counts cells that satisfy all supplied criteria pairs.

CSCH

CSCH: Returns the hyperbolic cosecant of a number, defined as `1 / SINH(x)`.

On this page

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