Formualizer Docs
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
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
12.34
Truncate toward zero at the hundreds place
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
-900

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

SummaryRemarksExamplesRelated functionsFAQHow does TRUNC differ from INT for negative numbers?Runtime metadata