ReferenceFunctionsEngineering Functions

IMSIN

IMSIN: Returns the sine of a complex number.

Summary

Evaluates complex sine 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

Sine of zero

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

0

Sine on imaginary axis

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

1.1752011936438014i

FAQ

Why can `IMSIN` return non-zero imaginary output for real-looking formulas?

For complex inputs a+bi, sine uses hyperbolic terms (cosh, sinh), so imaginary components are expected.

Runtime metadata

Category

Engineering

Signature

IMSIN(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.

IMSQRT

IMSQRT: Returns the principal square root of a complex number.

On this page

Summary Remarks Examples Related functions FAQ Why can IMSIN return non-zero imaginary output for real-looking formulas?Runtime metadata