ReferenceFunctionsMath Functions

SIGN

Returns the sign of a number as -1, 0, or 1.

Summary

Returns the sign of a number as -1, 0, or 1.

Remarks

Returns 1 for positive numbers.
Returns -1 for negative numbers.
Returns 0 when input is zero.

Examples

Positive input

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

1

Negative input

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

-1

FAQ

Can SIGN return anything other than -1, 0, or 1?

No. After numeric coercion, the output is always exactly -1, 0, or 1.

Runtime metadata

Category

Math

Signature

SIGN(arg1: Number)

Arity

min 1, max 1

Arguments

arg1

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

crates/formualizer-eval/src/builtins/math/numeric.rs

SERIESSUM

SERIESSUM: Evaluates a power series from coefficients, start power, and step.

SIN

Returns the sine of an angle in radians.

On this page

Summary Remarks Examples Related functions FAQ Can SIGN return anything other than -1, 0, or 1?Runtime metadata