Formualizer Docs
ReferenceFunctionsEngineering Functions

IMSEC

IMSEC: Returns the secant of a complex number.

Summary

Computes 1 / IMCOS(inumber) for an Excel-style complex number string.

Examples

Secant of zero
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
1

FAQ

How are poles represented?

Inputs that lead to non-finite results return #NUM!.

Runtime metadata

Category

Engineering

Signature

IMSEC(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

crates/formualizer-eval/src/builtins/engineering.rs

IMREAL

IMREAL: Returns the real coefficient of a complex number.

IMSECH

IMSECH: Returns the hyperbolic secant of a complex number.

On this page

SummaryExamplesRelated functionsFAQHow are poles represented?Runtime metadata