TRUNC
Math & TrigTRUNC helps you perform mathematical and trigonometric calculations for everyday analysis workflows.
Overview
Start with "=" then enter TRUNC(number, [digits]). Keep argument order as shown and use cell ranges where appropriate.
Parser pathComplete docs
Syntax & Arity
=TRUNC(number, [digits])
1 to 2 arguments
Arguments
| Argument | Required | Type | Description |
|---|---|---|---|
| number | Required | Single | Numeric input value. |
| digits | Optional | Single | Optional argument for advanced control. |
Example Inputs & Outputs
Formula
=TRUNC(<number>, <digits>)
Example Output
Numeric result
Replace placeholders with your worksheet values or ranges to compute a result.