Formualizer Docs
ReferenceFunctionsEngineering Functions

IMCOS

IMCOS: Returns the cosine of a complex number.

Summary

Evaluates complex cosine and returns the result as complex text.

Remarks

  • Input is coerced to complex-number text before parsing.
  • Uses hyperbolic components for the imaginary part.
  • Invalid complex text returns #NUM!.

Examples

Cosine of zero
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
1
Cosine on imaginary axis
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
1.5430806348152437

FAQ

Why is the imaginary part negated in IMCOS?

Complex cosine uses cos(a+bi)=cos(a)cosh(b)-i sin(a)sinh(b), so the imaginary term carries a minus sign.

Runtime metadata

Category

Engineering

Signature

IMCOS(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

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

IMCONJUGATE

IMCONJUGATE: Returns the complex conjugate of a complex number.

IMDIV

IMDIV: Returns the quotient of two complex numbers.

On this page

SummaryRemarksExamplesRelated functionsFAQWhy is the imaginary part negated in IMCOS?Runtime metadata