ReferenceFunctionsMath Functions

TRUNC

Truncates a number toward zero, optionally at a specified digit position.

Summary

Truncates a number toward zero, optionally at a specified digit position.

Remarks

If num_digits is omitted, truncation is to an integer.
Positive num_digits keeps decimal places; negative values zero places to the left.
Passing more than two arguments returns #VALUE!.

Examples

Truncate to two decimal places

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

12.34

FAQ

How does TRUNC differ from INT for negative numbers?

TRUNC removes digits toward zero, while INT floors toward negative infinity.

Runtime metadata

Category

Math

Signature

TRUNC(arg1: Number, arg2…: Number)

Arity

min 1, max variadic

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

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

TANH

TANH: Returns the hyperbolic tangent of a number.

Random Functions

Generated reference pages for Random functions.

On this page

Summary Remarks Examples Related functions FAQ How does TRUNC differ from INT for negative numbers?Runtime metadata